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
- 8521 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sunil kumar
Hello Nivedita,
I am not satisfied with ur answer the difference between
primary key and foreign key.I think the answer is reverse.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / bharanikumar
primary key does not allow null value,
but unique allow only one null value...
www.happylife.in
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / g priya
If a field is null the database engine makes the field to be 0
if not null is specified ,field must be given a value
Primary key is unique,not null,index where as Unique key has
1 null value
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / 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 |
What is a mysql view?
What is the use of i-am-a-dummy flag in mysql?
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
Is mysql open source?
What is the latest mysql version?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is orm in mysql?
Why do we use mysql?
What is dbms in mysql?
How do you stop an access query?
What is a result set object?
How can I create database in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
