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 include character strings in sql statements?
How do you determine the location of mysql data directory?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What is RMS Migrations
How to convert numeric values to character strings?
how many ways we can get the current date in mysql?
What is dump in mysql?
What are the different column comparison operators in mysql?
How many groups of data types?
Is oracle mysql free?
What is mysql database used for?
What is a mysql view?
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)