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
Can mysql and mariadb coexist?
How do I automate a backup in mysql?
How many concurrent queries can mysql handle?
What is max connections in mysql?
How do I change a procedure in mysql?
I want to find out all databases starting with ‘test’, I have access to?
How do I know if mysql is running on windows?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
Which is better mysql or mssql?
What is mysql server used for?
How much does mysql enterprise cost?
Is mysql a free database?
How do I truncate all tables in mysql?
How do I find mysql database?