叮叮 发表于 2015-5-17 18:44:39

1064 - You have an error in your SQL syntax; check the manual that correspond...

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 7

这种错误主要是由于,使用了现在版本的mysql不支持的命令引起的错误,比如
    从MYSQL5.5开始,TYPE=MYISAM这种类型的命令无法使用,MYSQL已经替换成ENGINE来代替TYPE,如果出现这种错误,批量替换TYPE=   替换成ENGINE=
    还有就是timestamp(14) 不能指定长度~这是时间类型~

页: [1]
查看完整版本: 1064 - You have an error in your SQL syntax; check the manual that correspond...