how to declare unique key in creating a table..?
Answers were Sorted based on User's Feedback
Answer / chandu
create table sales(prodid INT NOT NULL UNIQUE
QUANTITY INT);
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / pankaj
When we declare a primary key its a unique key. for that table.
Is This Answer Correct ? | 0 Yes | 1 No |
How do you rename a table in mysql?
Which datatype is used for email in mysql?
How do I start and stop mysql on windows?
Is mysqli faster than mysql?
What is the insert?
What do we use to remove duplicate records while fetching a data in mysql ?
How do I automate a backup in mysql?
How do I tune a mysql query?
Why do we use group by and order by function in mysql?
Is mysql a framework?
Explain triggers and stored procedures?
SELECT country,city FROM customers GROUP BY country ORDER BY city DESC