- MySQL Error
- Message: MySQL Query Error
- SQL: CREATE TABLE uchome_doing ( doid mediumint(8) unsigned NOT NULL auto_increment, uid mediumint(8) unsigned NOT NULL default '0', username varchar(15) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', message text NOT NULL, ip varchar(20) NOT NULL default '', from varchar(20) NOT NULL default '', replynum int(10) unsigned NOT NULL default '0', mood smallint(6) NOT NULL default '0', PRIMARY KEY (doid), KEY uid (uid,dateline), KEY dateline (dateline)) TYPE=MyISAM AUTO_INCREMENT=54
- Error: 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 'from varchar(20) NOT NULL default '', replynum int(10) unsigne
- Errno.: 1064
- Click here to seek help.
复制代码
请楼主详细说明一下,我是个菜鸟,在恢复备份的时候也遇到了这个问题,以上是我的代码,我打开备份文件的时候发现里面有好多from 有的是大写的FROM 还有类似fromuid这种的,应该该那些呢?
我试着改了几个,可恢复完还是错误1064 代码如下:
- Error: 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 '\r\n
- Errno.: 1064
复制代码
请玻璃女孩多多帮忙,谢谢啦 |