Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 8893 Views
- I also Faced
- E-Mail Answers
Answer Posted / nivedita
IF NULL is specified,the feild is allow to be left empty
without any value.
IF NOT NULL is specified,the field must be given a value. In
the absence of either a NULL or NOT NULL, NULL is assumed.
-------
Unique key can't be NULL.Primary key can be NULL.
Unique key always contain unique value,duplicate are not
allowed(genrally the system genrated key).Primary key maybe
repeated.
| Is This Answer Correct ? | 6 Yes | 35 No |
Post New Answer View All Answers
What is pdo :: fetch_assoc?
How to Change a users password from unix shell.
What are the differences between mysql vs sql server?
Write a query to find duplicate rows in table?
How we can get distinct columns values in mysql?
Will mysql remain free?
What are aggregate functions in mysql?
How do I create a database in mysql workbench?
Why we use mongodb instead of mysql?
What is the insert?
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
What is horizontally scalable?
How do I setup mysql?
What is mysql57?
What are the common mysql functions?
