how we can use more then one primary key in Single Table
Answer Posted / frank
Can't, but can create primary key with multiple columns:
CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How can you import tables from a sql file into a database by using the mysql client?
Can we store pdf files in mysql?
How do you flush privileges?
How many rows can mysql handle?
how to connect a php script with the mysql database?
How to upload a large file through phpmyadmin in mysql?
How to create trigger in mysql workbench?
How to see the create table statement of an existing table?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
What is database migration in mysql?
What is data type for image in mysql?
What is mysql default database?
How would concatenate strings in mysql?
What is the date format in mysql?
Explain Access Control Lists.