HalRau 06:14:14 | I am trying to create tables based on your sql_dump.txt file. I am getting the following error message. SQL query: CREATE TABLE category( cat_id int( 2 ) NOT NULL AUTO_INCREMENT , category varchar( 25 ) NOT NULL default '', PRIMARY KEY ( cat_id ) ) TYPE = MYISAM ; MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1 Please correct and sent me the file. Thanks, |
smo1234 06-16-2014 | remove the word 'TYPE=MyISAM' and try |
HalRau 06-16-2014 | That worked. Thanks |