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

Answer Posted / chandu

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

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why mongodb is faster than mysql?

677


How to get a version of mysql?

779


What you can use regular expression for in mysql? Support your answer with an example?

677


How does select query work?

690


how you will Create a database on the mysql server with unix shell.

776


How to execute mysql query in php?

691


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

761


How to get a list of columns in an existing table?

696


How you will show all data from a table.

767


What is regexp?

913


How is data stored in mysql?

719


What is schema in mysql?

706


How do you stop an access query?

711


What is procedure in mysql?

722


What is mysql default port number?

782