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 can you make a database as your current database?
What is delimiter $$?
What is the difference between mysql_fetch_array and mysql_fetch_object?
How can you take the backup and restore a mysql database using php?
How do I start mysql server?
Is mysql relational?
What are the functions of mysql?
How to display nth highest salary from a table in a mysql query?
What is difference between mysql and mariadb?
What are the steps involved in query processing?
What is blob storage?
What are the advantages of myisam over innodb?
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)