MySql Error Document

Error Number

  1064

Error Message

  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 17

Query String

  CREATE TABLE event1_attach ( `number` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `parentattach` INT( 11 ) NOT NULL , `parentnumber` INT( 11 ) NOT NULL , `name` VARCHAR( 30 ) NOT NULL , `passwd` VARCHAR( 30 ) NOT NULL , `mem_id` VARCHAR( 50 ) DEFAULT NULL , `item_id` VARCHAR( 50 ) DEFAULT NULL , `isadmin` INT( 1 ) DEFAULT NULL , `iphost` VARCHAR( 20 ) NOT NULL , `rdate` VARCHAR(20) NOT NULL , `attachment` TEXT NOT NULL , `hit` INT( 10 ) NOT NULL, INDEX ( `parentattach`), INDEX ( `parentnumber` ) , INDEX ( `mem_id`) ) TYPE = MYISAM

Please Click 'Url Back' Button !!