What?s the difference between PRIMARY KEY and UNIQUE in
MyISAM?
Answers were Sorted based on User's Feedback
Answer / amith
PRIMARY KEY cannot be null, so essentially PRIMARY KEY is
equivalent to UNIQUE NOT NULL
| Is This Answer Correct ? | 28 Yes | 8 No |
Answer / niraj kumar
primary key is not accept the null value.primary key is
always autoincrement.unique key is accept the one null
value.it is not a autoincrement.
| Is This Answer Correct ? | 4 Yes | 15 No |
Answer / manish
Primary Keys are used in building relationships between
tables in a database. (an index is automatically created on
the primary key). The difference between primary and
ordinary keys is that there can be multiple keys, but only
one primary key.
| Is This Answer Correct ? | 7 Yes | 20 No |
How do I set user privileges in mysql?
Does mysql case matter?
Is mysql a programming language?
What is mysql and how it works?
What is join in mysql? What are the different types of join?
How do stored procedures work?
how we can use more then one primary key in Single Table
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr
Explain the difference between delete and truncate.
How many tables will create when we create table, what are they?
How to create a table?
What is the difference between unix timestamps and mysql timestamps?
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)