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 to present a past time in hours, minutes and seconds?

984

What is indexing in mysql?

879

List the different types of normalization?

887

How does mysql store binary data?

894

What is row level locking in access?

830

What are the 3 main types of search queries?

784

What are the advantages of myisam over innodb?

919

What is text in mysql?

857

What is a join in mysql?

843

How to delete an existing column in a table?

885

How do I kill a mysql connection?

853

Is mysqli secure?

833

What language does mysql use?

832

What is the difference between now() and current_date()?

926

Is mysql a programming language?

833