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

What is the default password for mysql?

450

Can't connect mysql server on localhost?

493

What is a join? Explain the different types of mysql joins.

683

Is oracle better than mysql?

462

What are the two types of queries?

437

What is a string in mysql?

459

What are the disadvantages of stored procedures?

487

Write a query to count the number of rows of a table in mysql.

472

What is the use of mysqli_fetch_assoc?

484

What are the differences between char and varchar?

550

What are date and time data types?

487

Which statement is used to delete a table in MySQL.

473

What are the different types of triggers in mysql?

451

What is the usage of ENUMs in MySQL?

630

Create table employee (eno int(2),ename varchar(10)) ?

539