Error 1064 (Syntax error) after adding ENUM or Set types to table definition

2004-05-24 Thread Bartis, Robert M (Bob)
I created the dump file from my current DB to make adjustments and also migrate to Innodb tables. In the process I have tried to add some ENUM types in select table. Obviously, I am doing something wrong as each one give me a syntax error 1064 when I try to source in the text file. I've read

Re: Error 1064 (Syntax error) after adding ENUM or Set types to table definition

2004-05-24 Thread Michael Stassen
One of the tricky things about finding errors is that the error is often earlier than you expect. Mysql points out where it stopped understanding you, but often it's due to something on the line before. That's the case here. There's nothing wrong with your ENUM, but the previous line says