What is the main different between Null and NOT Null.
Difference between Primary and Unique Key.
How to Check the database from which application is it
possibe.
Answer Posted / amit kumar tiwari
primary key uniquely define each table and never allow NULL
value. But unique key may be NULL value.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how to display nth highest salary from a table in a mysql query? : Mysql dba
what is the difference between between and in operators in mysql?
Define REGEXP?
How do I run mysql on a mac?
How many queries can mysql handle?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What is the maximum number of records in mysql table?
What is blob storage?
How important is to list the column names when doing an insert?
What is meant by sharding?
What is cursor in mysql?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What are the differences between char and varchar data types?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
write a query to mysql in safe mode and to change the root password