Why do I get a MySQL 1064 error when attempting to create a MySQL table?
This error may be caused by a syntax error in the table creation SQL code. FileMaker field names often contain spaces and special characters or consist of MySQL database reserved words. These types of problems will cause MySQL error 1064 to be displayed while trying to create the database table. MySQL column names and table names consisting of reserved words should be renamed to avoid this type of conflict. Spaces should be removed or replaced with underscore “_” characters in order to create a syntactically correct MySQL column name.
Related Questions
- I am attempting to create a relationship between two tables in Access, but keep getting a type mismatch error, every time I attempt to run the query. What is the problem?
- When attempting to create an isometric, using the Isogen export facility, an error stating "Pure Virtual Function Call" is displayed. What is wrong?
- How can I resolve MySQL error 1117 when attempting to create a MySQL table to match my FileMaker database file?
