1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / jimi shah

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

What is row level locking?

0 Answers  

In which language mysql has been written?

0 Answers  

How to see table's field formats or description of table .

0 Answers  

How to dump one database for backup.

0 Answers  

What do you understand by mysql terminal?

0 Answers  




What is limit in mysql?

0 Answers  

How to write date and time literals?

0 Answers  

What is DCL in MySQL?

1 Answers  

How do I install the latest mysql on ubuntu?

0 Answers  

How do I tune a mysql query?

0 Answers  

How do I stop a mysql service?

0 Answers  

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

For more MySQL Interview Questions Click Here
Categories