mysql创建表时打错了怎么修改_mysql创建表时有错误，错在哪了。请指点。请看下面的代码...

CREATETABLEIFNOTEXISTS`2013_11_08_OperatorLog`(`ID`int(11)NOTNULLAUTO_INCREMENT,`EVENTID`int(11)defaultNULL,`UID`int(11)defaultNULL,`CID`int(11)defaultNULL,`S_DESC`varcha...

CREATE TABLE IF NOT EXISTS `2013_11_08_OperatorLog` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`EVENTID` int(11) default NULL,

`UID` int(11) default NULL,

`CID` int(11) default NULL,

`S_DESC` varchar(32) default NULL,

`TUID` int(11) default NULL,

`TCID` int(11) default NULL,

`D_DESC` varchar(32) default NULL,

`OPID` int(11) default NULL,

`WTCHG1` varchar(32) default NULL,

`CHGBEF1` bigint(20) default NULL,

`CHGAFT1` bigint(20) default NULL,

`WTCHG2` varchar(32) default NULL,

`CHGBEF2` bigint(20) default NULL,

`CHGAFT2` bigint(20) default NULL,

`WTCHG3` varchar(32) default NULL,

`CHGBEF3` bigint(20) default NULL,

`CHGAFT3` bigint(20) default NULL,

`BAK` text,

`OP_TIME` datetime default NULL,

`TYPE` int(11) default NULL,

`REG_TIME` datetime default NULL,

PRIMARY KEY (`ID`),

KEY index_CID(CID),

KEY index_UID(UID),

KEY index_S_DESC(S_DESC),

KEY index_TUID(TUID),

KEY index_TCID(TCID),

KEY index_D_DESC(D_DESC),

KEY index_OPID(OPID),

KEY index_TYPE(TYPE),

KEY index_REG_TIME(REG_TIME),

KEY index_CHGAFT1(CHGAFT1),

KEY index_WTCHG1(WTCHG1),

KEY index_CHGBEF1(CHGBEF1),

KEY index_union1(CID,TYPE,CHGAFT1,WTCHG1),

KEY index_union2(CID,TYPE)

) TYPE=MyISAM max_rows=4294967295 avg_row_length=200000000;

,-204,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 max_rows=4294967295 avg_row_length=200000000' at line 39

展开