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 |
What are features of mysql?
How do I clear the command in mysql?
What is memory table?
What is mysql protocol?
How to extract a unit value from a date and time?
What is the function of myisamchk?
What is mysqlcheck do?
What is 'mysqlcheck'?
How to copy data from one server to another using php?
How can we find the number of rows in a table using MySQL?
Is mysql open source?
What is mysql command line?
Oracle (3253)
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)