Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 16317 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
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How to add a new column to an existing table in mysql?
What are aggregate functions in mysql?
Can you tell which of the following where clauses is faster?
How big is a blob mysql?
What is the use of mysqli_query?
How to update info already in a table and delete a row(s) from a table.
Can we rollback truncate in mysql?
Where the database is stored in mysql?
Where is the mysql data directory?
What is mysql used for?
What is database engine in mysql?
How do you login to MySql using Unix shell?
What are slow queries?
