create table sales(prodid INT NOT NULL UNIQUE QUANTITY

how to declare unique key in creating a table..?

Question Posted / chandu

Answer Posted / chandu

create table sales(prodid INT NOT NULL UNIQUE
QUANTITY INT);

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I view data in mysql workbench?

1004

Is mysql same as sql?

884

Can python connect to mysql?

1000

What is delimiter in mysql?

865

What is mysql_query?

848

How to display odd rows in student table in mysql?

987

What is the difference between mysql and pdo?

968

Can we create table in stored procedure?

950

What is mysql connection limit?

922

Is there a way to see the files which are stored?

966

How do you stop an access query?

902

What is the difference between procedure and function in mysql?

1011

What is default password for mysql?

857

How to find the unique values if the value in the column is repeated?

966

In how many ways we can retrieve data in the result set of mysql using php?

1117