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 extract a unit value from a date and time?
How do I create a schema in mysql?
How do I clear a mysql database?
List the different types of normalization?
How do I insert an image into mysql workbench?
Is there a free mysql?
What are mysql functions?
How to Change a users password from unix shell.
How to get help information from the server?
How do I disconnect mysql workbench?
Create table employee (eno int(2),ename varchar(10)) ?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
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)