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 get a list of columns in an existing table?
What is mysql sleep process?
Restore database (or database table) from backup.
How to use triggers to track changes in mysql?
What is an example of a delimiter?
What is pragma serially_reusable and why is it used?
How do you select a table?
What ascii 31?
What is mysql enterprise edition?
How to create a test table in your mysql server?
How many ways to get the current time?
can you elaborate on blob and text in mysql? : Mysql dba
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)