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 connect to mysql database?
Can you tell the difference between $message and $$message?
Which mysql function is used to concatenate string?
How to use regular expression in pattern match conditions?
How do I edit a database in mysql workbench?
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.
What are date and time data types in mysql?
Is mysql a free database?
What is mysqlcommand?
What are procedures in mysql? Explain
How do you convert to a different table type?
How can you change the name of any existing table by using the sql statement?
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)