Wednesday, July 17, 2019

ERROR 1064 (42000) in MySQL

Tried to import a sql script that was the product of forward engineering of an EER diagram done in MySQL Workbench (I had not modified it at all) but I was getting a persistent "ERROR 1064 (42000)" although it all seemed to be in order.

This is a pretty generic error that can occur in a number of different situations but in my case it turns out it was due to an empty table, i.e. a table defined in the schema but having no rows at all, including a Primary Key (PK) column. Once I defined that the error went away.

No comments:

Post a Comment