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. Conversion failed when converting date and/or time from character string while inserting datetime
  72. how to fix oracle ORA-01722 invalid number error
  73. How do I escape a single quote in SQL Server?
  74. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  75. Combining “LIKE” and “IN” for SQL Server
  76. 1052: Column ‘id’ in field list is ambiguous
  77. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  78. How to store arrays in MySQL?
  79. Oracle “Partition By” Keyword
  80. What is the equivalent of ‘describe table’ in SQL Server?
  81. Add a column with a default value to an existing table in SQL Server
  82. SQL ZOO List each continent and the name of the country that comes first alphabetically
  83. What is the difference between a stored procedure and a view?
  84. DATEDIFF function in Oracle
  85. How to do a batch insert in MySQL
  86. GROUP BY and COUNT using ActiveRecord
  87. Optimize WordPress Query that take 5 seconds to execute
  88. Multipart/formatted MySQL query problem
  89. Extending the database
  90. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  91. How do I escape a table name or column name in SQL? esc_sql doesn’t do this
  92. Alter wp_post table vs. post_meta performance/speed
  93. How to prevent/delay MySQL connections when an object cache is used?
  94. Clean up very big and very dirty database
  95. What is the point of get_comment_count() if you cannot limit by a comment type?
  96. Bulk delete WordPress Post and all metadata, etc using SQL query
  97. How to create index (sql) to a meta_key?
  98. Display MySQL as part of a Page
  99. SQL query to remove first image in all posts
  100. Query sql for truncate post_content in wp_posts table

Leave a Comment