Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 15943 Views
- Systematix, I also Faced
- E-Mail Answers
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
What is acid in mysql?
How do you kill a long running query in mysql?
In mysql, what is the default storage engine?
What is query log in mysql?
Write a query to count the number of rows of a table in mysql.
How to enter Characters as HEX Numbers?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How many columns can a mysql table have?
How to connect html form to mysql database using php?
What is the default port for MySQL Server?
What is data in mysql?
What is the use of mysqli_query?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
What is the use of mysql_fetch_array () function in php?
How to use like conditions?
