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

Can we store images in mysql database?

677

What is a tinyint in mysql?

688

What happens if you no create privilege in a database?

789

What's new in mysql 8?

771

How can you make a database as your current database?

698

Is mysql server free?

675

What is auto increment in mysql?

735

What is the difference between truncate and delete?

797

What are mysql functions?

697

Where MyISAM table will be stored and also give their formats of storage?

851

What is mysql aggregate functions? Explain

767

What is pdo :: fetch_assoc?

685

What is procedural api?

712

What is the hostname for mysql database?

726

How to get current MySQL version?

800