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

Answers were Sorted based on User's Feedback



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

Answer / chandu

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

Is This Answer Correct ?    6 Yes 2 No

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

Answer / pankaj

When we declare a primary key its a unique key. for that table.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More MySQL Interview Questions

How do you rename a table in mysql?

0 Answers  


Which datatype is used for email in mysql?

0 Answers  


How do I start and stop mysql on windows?

0 Answers  


Is mysqli faster than mysql?

0 Answers  


What is the insert?

0 Answers  






What do we use to remove duplicate records while fetching a data in mysql ?

0 Answers  


How do I automate a backup in mysql?

0 Answers  


How do I tune a mysql query?

0 Answers  


Why do we use group by and order by function in mysql?

0 Answers  


Is mysql a framework?

0 Answers  


Explain triggers and stored procedures?

0 Answers  


SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,


Categories