how to declare unique key in creating a table..?
Answers were Sorted based on User's Feedback
Answer / chandu
create table sales(prodid INT NOT NULL UNIQUE
QUANTITY INT);
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / pankaj
When we declare a primary key its a unique key. for that table.
| Is This Answer Correct ? | 0 Yes | 1 No |
How to present a past time in hours, minutes and seconds?
what is the procedure to configure the application of mysql?
What is new mysqli?
Which is faster innodb or myisam?
How many columns is too many mysql?
How do I setup a mysql database?
What data type is money?
What is procedure in mysql?
What are the applications required to support mysql?
Is postgresql better than mysql?
Is mysql a distributed database?
Explain the difference between primary key and candidate key in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)