Subject: | MySQL Parser doesn't recognise CHARSET commands |
I tried to convert
CREATE TABLE category (
id INTEGER PRIMARY KEY auto_increment, -- category
name VARCHAR(255) ,
cluster ENUM('0','1') not NULL default '1',
created DATETIME
) TYPE=InnoDB CHARACTER SET utf8;
and I had to s/CHARACTER SET utf8//gis;
because the Parser always complained about expecting something like create, drop, etc.