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 do you start and stop MySQL on Windows?
Can you tell which of the following where clauses is faster?
What is cursor in mysql?
How to delete the repeated records from a table?
Is mysql a dbms?
How do I edit a database in mysql workbench?
Is null in mysql?
Is sql and mysql same?
Does uninstalling mysql delete database?
What are the functions used to encrypt and decrypt the data present in mysql?
In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?
What are the difference between and myisam and 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)