“Unknown column in ‘field list'”, but column does exist

by

There is an unprintable character 30 (RecordSeparator) inserted between purchase_date and the ' in the INSERT statement. Just remove the text ('purchase_date') and rewrite it by hand it should be fine.

More Related Contents:

  1. How to do a batch insert in MySQL
  2. Restore table structure from frm and ibd files
  3. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  4. How to convert all tables from MyISAM into InnoDB?
  5. Prevent auto increment on MySQL duplicate insert
  6. How to copy a row and insert in same table with a autoincrement field in MySQL?
  7. MySQL Error 1264: out of range value for column
  8. How do I get the ID of multiple inserted rows in MySQL?
  9. How to insert data to MySQL with auto-incremented column(field)?
  10. MySQL INSERT INTO … VALUES and SELECT
  11. MySQL error 1241: Operand should contain 1 column(s)
  12. How to enable INNODB in mysql
  13. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  14. How to regex in a MySQL query
  15. MySQL optimizing INSERT speed being slowed down because of indices
  16. MySQL: Insert datetime into other datetime field
  17. Insert and set value with max()+1 problems
  18. how to delete data from table A besides the customer service and director data in table B?
  19. Get records with max value for each group of grouped SQL results
  20. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  21. MySQL Conditional Insert
  22. MySQL: View with Subquery in the FROM Clause Limitation
  23. MySql export schema without data
  24. MySQL trigger On Insert/Update events
  25. MySQL: LIMIT by a percentage of the amount of records?
  26. MySQL Inner Join Query Multiple Tables
  27. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  28. MySQL LEFT JOIN 3 tables
  29. MySql using correct syntax for the over clause
  30. Optimistic locking in MySQL

Leave a Comment