错误
SQL 查询:CREATE TABLE `accdelt` ( `AUTOID` BIGINT( 20 ) NOT NULL ,
`ID` VARCHAR( 5 ) DEFAULT NULL ,
`ACCID` VARCHAR( 5 ) DEFAULT NULL ,
`CON01` VARCHAR( 16 ) NOT NULL DEFAULT '',
`CON02` VARCHAR( 15 ) DEFAULT NULL ,
`CON03` VARCHAR( 15 ) DEFAULT NULL ,
`CON04` VARCHAR( 10 ) DEFAULT NULL ,
`CON05` VARCHAR( 8 ) DEFAULT NULL ,
`CON06` VARCHAR( 8 ) DEFAULT NULL ,
`CON07` DATE DEFAULT NULL ,
`CON08` VARCHAR( 30 ) DEFAULT NULL ,
`CON09` VARCHAR( 30 ) DEFAULT NULL ,
`CON10` VARCHAR( 30 ) DEFAULT NULL ,
`CON11` VARCHAR( 30 ) DEFAULT NULL ,
`CON12` VARCHAR( 30 ) DEFAULT NULL ,
`CON13` VARCHAR( 30 ) DEFAULT NULL ,
`DT999` DATETIME DEFAULT NULL ,
`DT998` TINYINT( 1 ) DEFAULT '0',
PRIMARY KEY ( `AUTOID` )
) TYPE = INNODB COMMENT = '联系人资料表' AUTO_INCREMENT =78
MySQL 返回:文档#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=InnoDB COMMENT='è
我用的是Phpmyadmin建立表,出现了下面问题!!谢谢指点,,是不是中文,就不行啊,那怎么办啊?!
SQL 查询:CREATE TABLE `accdelt` ( `AUTOID` BIGINT( 20 ) NOT NULL ,
`ID` VARCHAR( 5 ) DEFAULT NULL ,
`ACCID` VARCHAR( 5 ) DEFAULT NULL ,
`CON01` VARCHAR( 16 ) NOT NULL DEFAULT '',
`CON02` VARCHAR( 15 ) DEFAULT NULL ,
`CON03` VARCHAR( 15 ) DEFAULT NULL ,
`CON04` VARCHAR( 10 ) DEFAULT NULL ,
`CON05` VARCHAR( 8 ) DEFAULT NULL ,
`CON06` VARCHAR( 8 ) DEFAULT NULL ,
`CON07` DATE DEFAULT NULL ,
`CON08` VARCHAR( 30 ) DEFAULT NULL ,
`CON09` VARCHAR( 30 ) DEFAULT NULL ,
`CON10` VARCHAR( 30 ) DEFAULT NULL ,
`CON11` VARCHAR( 30 ) DEFAULT NULL ,
`CON12` VARCHAR( 30 ) DEFAULT NULL ,
`CON13` VARCHAR( 30 ) DEFAULT NULL ,
`DT999` DATETIME DEFAULT NULL ,
`DT998` TINYINT( 1 ) DEFAULT '0',
PRIMARY KEY ( `AUTOID` )
) TYPE = INNODB COMMENT = '联系人资料表' AUTO_INCREMENT =78
MySQL 返回:文档#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=InnoDB COMMENT='è
我用的是Phpmyadmin建立表,出现了下面问题!!谢谢指点,,是不是中文,就不行啊,那怎么办啊?!
CREATE TABLE `accdelt` ( `AUTOID` BIGINT( 20 ) NOT NULL ,
`ID` VARCHAR( 5 ) DEFAULT NULL ,
`ACCID` VARCHAR( 5 ) DEFAULT NULL ,
`CON01` VARCHAR( 16 ) NOT NULL DEFAULT '',
`CON02` VARCHAR( 15 ) DEFAULT NULL ,
`CON03` VARCHAR( 15 ) DEFAULT NULL ,
`CON04` VARCHAR( 10 ) DEFAULT NULL ,
`CON05` VARCHAR( 8 ) DEFAULT NULL ,
`CON06` VARCHAR( 8 ) DEFAULT NULL ,
`CON07` DATE DEFAULT NULL ,
`CON08` VARCHAR( 30 ) DEFAULT NULL ,
`CON09` VARCHAR( 30 ) DEFAULT NULL ,
`CON10` VARCHAR( 30 ) DEFAULT NULL ,
`CON11` VARCHAR( 30 ) DEFAULT NULL ,
`CON12` VARCHAR( 30 ) DEFAULT NULL ,
`CON13` VARCHAR( 30 ) DEFAULT NULL ,
`DT999` DATETIME DEFAULT NULL ,
`DT998` TINYINT( 1 ) DEFAULT '0',
PRIMARY KEY ( `AUTOID` )
) engine = INNODB
谢谢.我查了mysql后的就改为了engine..但是后面的"COMMENT = '联系人资料表' AUTO_INCREMENT =78"这部分要去掉嘛?!