set charset utf8;
CREATE TABLE `admin` (
`id` int(11) NOT NULL auto_increment,
`admin` varchar(100) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`time_at` datetime NOT NULL default '0000-00-00 00:00:00',
`ip` varchar(15) NOT NULL default '',
`Jurisdiction` char(2) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;insert into `admin`(`id`,`admin`,`password`,`time_at`,`ip`,`Jurisdiction`) values('1','admin','admin','2007-06-22 14:10:52','127.0.0.1','1');CREATE TABLE `content` (
`id` int(10) NOT NULL auto_increment,
`sname` varchar(10) NOT NULL default '',
`ssex` char(2) NOT NULL default '',
`sQQ` varchar(13) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`content` mediumtext NOT NULL,
`sHead` varchar(50) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`time_at` datetime NOT NULL default '0000-00-00 00:00:00',
`re_plery` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `eye_act` (
`id` int(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`hosname` varchar(60) NOT NULL default '',
`content` text NOT NULL,
`resum` smallint(5) default '1',
`recom` enum('是','否') default '否',
`rearea` enum('是','否') default '否',
`vdate` varchar(12) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
这是数据备份文件的内容,在5.0mysql中还原总是出现错误具体错误如下:[Err] 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 ''<p>爱在新乡' at line 1
[Err] insert into `eye_act`(`id`,`title`,`city`,`hosname`,`content`,`resum`,`recom`,`rearea`,`vdate`) values('4','D爱在新乡D爱在新乡D爱在新乡D……
[Err] 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 ' ' at line 1一直会出现这种错误,希望有懂的人给出错误原因和解决办法,在线等大虾解答!!!(由于网站空间到期现在继续还原数据),拜谢了!!!还有一点我这是上传虚拟主机的数据库!!!不要拿本地的来说事!!!
CREATE TABLE `admin` (
`id` int(11) NOT NULL auto_increment,
`admin` varchar(100) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`time_at` datetime NOT NULL default '0000-00-00 00:00:00',
`ip` varchar(15) NOT NULL default '',
`Jurisdiction` char(2) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;insert into `admin`(`id`,`admin`,`password`,`time_at`,`ip`,`Jurisdiction`) values('1','admin','admin','2007-06-22 14:10:52','127.0.0.1','1');CREATE TABLE `content` (
`id` int(10) NOT NULL auto_increment,
`sname` varchar(10) NOT NULL default '',
`ssex` char(2) NOT NULL default '',
`sQQ` varchar(13) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`content` mediumtext NOT NULL,
`sHead` varchar(50) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`time_at` datetime NOT NULL default '0000-00-00 00:00:00',
`re_plery` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `eye_act` (
`id` int(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`hosname` varchar(60) NOT NULL default '',
`content` text NOT NULL,
`resum` smallint(5) default '1',
`recom` enum('是','否') default '否',
`rearea` enum('是','否') default '否',
`vdate` varchar(12) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
这是数据备份文件的内容,在5.0mysql中还原总是出现错误具体错误如下:[Err] 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 ''<p>爱在新乡' at line 1
[Err] insert into `eye_act`(`id`,`title`,`city`,`hosname`,`content`,`resum`,`recom`,`rearea`,`vdate`) values('4','D爱在新乡D爱在新乡D爱在新乡D……
[Err] 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 ' ' at line 1一直会出现这种错误,希望有懂的人给出错误原因和解决办法,在线等大虾解答!!!(由于网站空间到期现在继续还原数据),拜谢了!!!还有一点我这是上传虚拟主机的数据库!!!不要拿本地的来说事!!!
`recom` enum('是','否') default '否',
`rearea` enum('是','否') default '否',
不正确。改为
`recom` enum('否','是') not null,
`recom` enum('否','是') not null,
原因:如果ENUM列被声明为NOT NULL,其默认值为允许的值列的第1个元素。然后你再插入试试
提示