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 / kalpana
Primary key can never be NULL.it is used to uniquely
identify the row in a table.The database engine requeir a
value to relocate the record.so Primary key can never be
NUL.unique key may be NULL.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
Does adding an index lock a table?
What are the non-standard sql commands supported by 'mysql'?
How do I delete a table in mysql workbench?
Which command is used to view the content of the table in mysql?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is action query?
Is sql and mysql same?
How to get the current date in mysql?
What is a tinyint?
Explain the storage engines in mysql?
What is ISAM?
Which statement is used to delete a table in MySQL.
What is default schema in mysql?
What do I do if I forgot my mysql root password?
What is the default port for MySQL Server?