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 is use of mysql?
What is different between sql and mysql?
How to define numeric 9(3) in db2 table without decimal point??
What is the difference between truncate and delete in mysql?
suppose server is running Suddenly down . what can you do? but i want do not down the server?
What is the latest mysql?
What is tee command in mysql?
What is unique key in mysql?
how we can find nth max salary from an employe table by using my sql?
Is there a free mysql?
Is there an object-oriented version of MySQL library functions?
What are Heap tables?
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)