MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET

As far as I can tell, both syntaxes are equivalent. The first is SQL standard, the second is MySQL’s extension.

So they should be exactly equivalent performance wise.

http://dev.mysql.com/doc/refman/5.6/en/insert.html says:

INSERT inserts new rows into an existing table. The INSERT … VALUES and INSERT … SET forms of the statement insert rows based on explicitly specified values. The INSERT … SELECT form inserts rows selected from another table or tables.

Related Posts:

  1. Best way to test if a row exists in a MySQL table
  2. What’s the best way to search for a UPC code in a Database?
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. MySQL – Operand should contain 1 column(s)
  7. When should I use CROSS APPLY over INNER JOIN?
  8. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. MySQL create table if not exists and insert record only if table was created
  11. How do I use properly CASE..WHEN in MySQL
  12. How can I do a FULL OUTER JOIN in MySQL?
  13. MySQL query String contains
  14. What’s the difference between VARCHAR and CHAR?
  15. Case statement in MySQL
  16. How to declare a variable in MySQL?
  17. MySQL Cannot Add Foreign Key Constraint
  18. How to split the name string in mysql?
  19. How do I import an SQL file using the command line in MySQL?
  20. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  21. mysql Foreign key constraint is incorrectly formed error
  22. MySQL: Invalid use of group function
  23. How can I return pivot table output in MySQL?
  24. Compare dates in MySQL
  25. MySQL “WITH” clause
  26. MySQL Multiple Joins in one query?
  27. Error Code: 2013. Lost connection to MySQL server during query
  28. MySQL syntax for Join Update
  29. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  30. how to drop partition without dropping data in MySQL?
  31. MySQL combine two columns into one column
  32. Simple way to calculate median with MySQL
  33. Error 1046 No database Selected, how to resolve?
  34. MySQL Error 1264: out of range value for column
  35. Count(*) vs Count(1) – SQL Server
  36. Remove duplicate rows in MySQL
  37. How to SUM and SUBTRACT using SQL?
  38. Cast from VARCHAR to INT – MySQL
  39. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  40. How do you force mysql LIKE to be case sensitive?
  41. MySQL – UPDATE multiple rows with different values in one query
  42. How to create a MySQL hierarchical recursive query?
  43. ERROR 1148: The used command is not allowed with this MySQL version
  44. Insert into a MySQL table or update if exists
  45. How to round down to nearest integer in MySQL?
  46. MySQL starts with searching issue
  47. Query to convert from datetime to date mysql
  48. Is it possible to GROUP BY multiple columns using MySQL?
  49. MySQL error: key specification without a key length
  50. Check if MySQL table exists without using “select from” syntax?
  51. MySQL equivalent of DECODE function in Oracle
  52. mysql update column with value from another table
  53. The used SELECT statements have a different number of columns
  54. How to delete from multiple tables in MySQL?
  55. MySQL: Can’t create table (errno: 150)
  56. How to copy a row and insert in same table with a autoincrement field in MySQL?
  57. Join vs. sub-query
  58. Alternative to except in MySQL
  59. Equivalent of explode() to work with strings in MySQL
  60. ROW_NUMBER() in MySQ
  61. MySQL OPTIMIZE all tables?
  62. MySQL – Get row number on select
  63. MySQL error: Unknown column in ‘where clause’
  64. How to truncate the text returned for a column in a MySQL query
  65. Using union and order by clause in mysql
  66. MySQL LIKE IN()?
  67. What’s the best way to dedupe a table?
  68. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  69. Debugging WordPress
  70. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1
  71. Using group by on multiple columns
  72. Efficiently convert rows to columns in sql server
  73. Nested select statement in SQL Server
  74. Sql Server equivalent of a COUNTIF aggregate function
  75. SQL – HAVING vs. WHERE
  76. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  77. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  78. How can I prevent SQL injection in PHP?
  79. How can I do ‘insert if not exists’ in MySQL?
  80. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  81. postgresql: error duplicate key value violates unique constraint
  82. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  83. Convert timestamp to date in Oracle SQL
  84. Update statement with inner join on Oracle
  85. #1062 – Duplicate entry for key ‘PRIMARY’
  86. SQLite string contains other string query
  87. WordPress SQL LIKE request doesn’t work for fields with special symbols
  88. Concurrent / simultaneous MySQL connections
  89. Improve performance by removing unnecessary database queries
  90. How can I add a new row in a separate database when someone registers via WordPress?
  91. WP MultiSite: Can’t select database error after changing to new domain
  92. $wpdb->get_var – What value is returned when zero records are found?
  93. How to avoid filling up an array each time I run a WP_query?
  94. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  95. Database SQL query error
  96. Organising and completing posts (mark as read and hide)
  97. can’t delete a row from post_meta table
  98. SQL error on restoring database
  99. Creating a “forum” – showing last post or last commented post
  100. Can running a WP-Cron to update_post_meta cause performance issues?

Leave a Comment