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

What is delimiter in mysql trigger?

995

What is difference between group by and order by clause?

1012

Why we use mysql workbench?

953

How many concurrent queries can mysql handle?

941

How do I view tables in mysql workbench?

973

What is mysql57?

969

How do I restore a mysql database dump file in linux?

1028

What are the method you will follow while sql installing

2400

How do I rename a mysql database?

1001

What is current version of mysql?

1038

What do you need to connect php to mysql?

1034

What is difference between pdo and mysqli?

1036

How to convert dates to character strings?

1132

Is sql and mysql same?

989

Can you tell the difference between $message and $$message?

1029