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
- 8899 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 sql does mysql use?
How do I create a database in mysql workbench?
What is mysql url?
Explain the architecture models of SQL Server?
How to dump a table from a database.
What is the latest version of php and mysql?
How many columns can a mysql table have?
List some comparisons operators used in mysql?
What is the function of myisamchk?
What is a join? Explain the different types of mysql joins.
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?
A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.
-
Oracle (3253) - 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)
