Reserved word in column name – insert into MySQL [duplicate]

by

Try:

INSERT INTO users (`name`, `group`) VALUES ('John', '9')

More Related Contents:

  1. Syntax error due to using a reserved word as a table or column name in MySQL
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. MySQL Conditional Insert
  4. How to set initial value and auto increment in MySQL?
  5. How to do a batch insert in MySQL
  6. Get the new record primary key ID from MySQL insert query?
  7. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  8. LAST_INSERT_ID() MySQL
  9. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  10. MySql Table Insert if not exist otherwise update
  11. MySQL trigger On Insert/Update events
  12. How to copy a row and insert in same table with a autoincrement field in MySQL?
  13. MySQL Error 1264: out of range value for column
  14. BULK INSERT in MYSQL
  15. How do I get the ID of multiple inserted rows in MySQL?
  16. MySQL trigger to update a field to the value of id
  17. Importing a CSV to MySQL with different date format
  18. How to insert data to MySQL with auto-incremented column(field)?
  19. How to insert values in table with foreign key using MySQL?
  20. MySQL error 1241: Operand should contain 1 column(s)
  21. MySQL Insert & Joins
  22. How to add a where clause in a MySQL Insert statement?
  23. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  24. MySQL – insert data from another table merged with constants
  25. MySQL optimizing INSERT speed being slowed down because of indices
  26. MySQL: Insert datetime into other datetime field
  27. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  28. Incorrect integer value: ” for column ‘id’ at row 1
  29. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?
  30. Insert and set value with max()+1 problems

Leave a Comment