difference between primary key and unique key

Primary Key:

  • There can only be one primary key constraint in a table
  • In some DBMS it cannot be NULL – e.g. MySQL adds NOT NULL
  • Primary Key is a unique key identifier of the record

Unique Key:

  • Can be more than one unique key in one table
  • Unique key can have NULL values
  • It can be a candidate key
  • Unique key can be NULL ; multiple rows can have NULL values and therefore may not be considered “unique”

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How do I restore a dump file from mysqldump?
  4. 1052: Column ‘id’ in field list is ambiguous
  5. 1052: Column ‘id’ in field list is ambiguous
  6. How to do a batch insert in MySQL
  7. Remove Primary Key in MySQL
  8. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  9. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  10. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  11. Cannot delete or update a parent row: a foreign key constraint fails
  12. Cannot delete or update a parent row: a foreign key constraint fails
  13. Rename a column in MySQL
  14. Cannot delete or update a parent row: a foreign key constraint fails
  15. How do I import an SQL file using the command line in MySQL?
  16. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  17. What is the definition of cardinality in SQL
  18. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  19. When to use SELECT … FOR UPDATE?
  20. SQL Query Where Field DOES NOT Contain $x
  21. Create a new database with MySQL Workbench
  22. Error Code: 2013. Lost connection to MySQL server during query
  23. Column ‘user_id’ in field list is ambiguous
  24. How to join two tables by multiple columns in SQL?
  25. How to get size of mysql database?
  26. Selecting data from two different tables without using joins
  27. Creating a search form in PHP to search a database?
  28. How can I do ‘insert if not exists’ in MySQL?
  29. Simple Random Samples from a Sql database
  30. What does SQL clause “GROUP BY 1” mean?
  31. SQL ZOO List each continent and the name of the country that comes first alphabetically
  32. How can I prevent SQL injection in PHP?
  33. How can I do ‘insert if not exists’ in MySQL?
  34. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  35. Generating a random & unique 8 character string using MySQL
  36. SQL select only rows with max value on a column
  37. Unknown Column In Where Clause
  38. Repair all tables in one go
  39. MySQL equivalent of DECODE function in Oracle
  40. How to create a foreign key in phpmyadmin
  41. How to check if mysql database exists
  42. #1062 – Duplicate entry for key ‘PRIMARY’
  43. Is there a Profiler equivalent for MySql?
  44. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  45. MySQL: Cloning a MySQL database on the same MySql instance
  46. How to properly create composite primary keys – MYSQL
  47. Is merge statement available in MySQL
  48. How to get the count of each distinct value in a column?
  49. Data is not constantly loading from custom wordpress table
  50. How do you properly prepare a %LIKE% SQL statement?
  51. Optimize WordPress Query that take 5 seconds to execute
  52. Getting wrong relationship value in $args in wp_Query?
  53. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  54. Inserting Post Meta From SQL
  55. How to Join two tables from separate databases within WordPress
  56. Extending the database
  57. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  58. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  59. Query WordPress database by registered date and role
  60. Size article thumbnails and retrieve them directly from database
  61. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  62. Database Tables Lost Indexes? How to Recover?
  63. SQL Database, repeated tables?
  64. Create table from array with prepare
  65. Migrating to WordPress Recipe Plugin and Some SQL Issues
  66. Code to remove authors with no posts connected to them
  67. SQL command to convert all tags in lowercase?
  68. SQL Query in WordPress – Getting Impossible WHERE error
  69. Why this query is not showing any result on wordpresss home page?
  70. Using AND and bracket grouping in SQL not working
  71. Why does changing Database Table Prefixes result in loss of content?
  72. WP MultiSite: Can’t select database error after changing to new domain
  73. How can I write a formal sql query to get data from a custom table
  74. $wpdb->get_var – What value is returned when zero records are found?
  75. Data is not constatntly loading from custom wordpress table
  76. Lock wait timeout exceeded; try restarting transaction
  77. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  78. SQL query to change custom field in WordPress database
  79. Bulk find & replace on WordPress posts/pages (minus image paths)
  80. How to create index (sql) to a meta_key?
  81. Improving performance of SQL sub-queries in WordPress
  82. Delete all users meta that named: user_avatar
  83. An SQL query to find orphaned image attachments and their meta
  84. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  85. Display MySQL as part of a Page
  86. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  87. can’t delete a row from post_meta table
  88. get_results() query not working only when entering strings
  89. SQL error on restoring database
  90. optimise SQL wordpress call
  91. Query sql for truncate post_content in wp_posts table
  92. Woocommerce: Grab total revenue of a product over all orders
  93. export individual posts to text files or a single csv file
  94. SQL query : Select a thumbnail for a media
  95. SQL – Pull products of particular category from a remote WordPress woocommerce db
  96. why you don’t Implement PDO for access every thing to database
  97. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  98. SQL get last entry of a specific gravity form
  99. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment