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 |
The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
What are the disadvantages of mysql?
How do I view data in mysql workbench?
How many types of indexes are there in mysql?
What is full form of xampp?
What is the use of indexing table?
How can I remotely connect to mysql database?
What is mysql procedure?
What are the common mysql functions?
Why mongodb is faster than mysql?
how to find max salary from the database
How many tables will create when we create table, what are they?