以下是打印错误的信息,表示看不懂这个错误
======
DROP TABLE IF EXISTS a;
CREATE TABLE `a` (
`id` int(11) NOT NULL,
`uname` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `a` VALUES('1','a');
INSERT INTO `a` VALUES('2','a');
DROP TABLE IF EXISTS article;
CREATE TABLE `article` (
`aid` int(11) NOT NULL AUTO_INCREMENT,
`artid` int(11) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
`aname` varchar(25) DEFAULT NULL,
`piclink` varchar(50) DEFAULT NULL,
`artor` varchar(80) DEFAULT NULL,
`address` varchar(20) DEFAULT NULL,
`download` varchar(60) DEFAULT NULL,
`content` text,
`mname` varchar(20) DEFAULT NULL,
`click` int(11) DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
`atime` datetime DEFAULT NULL,
`mid` int(11) DEFAULT NULL,
`isdel` int(11) DEFAULT '0',
`istuangou` int(11) DEFAULT '0',
`artivityid` int(11) DEFAULT NULL,
`isjifen` int(11) DEFAULT '0',
`ispaimai` int(11) DEFAULT '0',
`isbao` int(11) DEFAULT '0',
`isyouhui` int(11) DEFAULT '0',
PRIMARY KEY (`aid`),
KEY `FK_ID` (`artid`),
KEY `FK_ID2` (`uid`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `article` VALUES('10','4','0','','5520ff21973fd.jpg','','','','','','200','','2015-04-05 00:00:00','1','0','0','0','0','0','0','0');
DROP TABLE IF EXISTS b;
CREATE TABLE `b` (
`id` int(11) NOT NULL,
`uname` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `b` VALUES('2','a');
INSERT INTO `b` VALUES('1','a');
DROP TABLE IF EXISTS bao;
CREATE TABLE `bao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`artname` varchar(255) DEFAULT NULL,
`starttime` int(11) DEFAULT NULL,
`endtime` int(11) DEFAULT NULL,
`upprice` int(11) DEFAULT NULL,
`downprice` int(11) DEFAULT '0',
`maxprice` int(11) DEFAULT '0',
`jifen` int(11) DEFAULT '1',
`instruction` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `bao` VALUES('1','','1428422400','1428508800','0','1','0','1','','0');
DROP TABLE IF EXISTS cat;
CREATE TABLE `cat` (
`mid` int(11) NOT NULL AUTO_INCREMENT,
`mname` varchar(30) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`path` varchar(50) DEFAULT NULL,
PRIMARY KEY (`mid`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `cat` VALUES('1','','0','0,');
INSERT INTO `cat` VALUES('4','','1','0,1,');
INSERT INTO `cat` VALUES('5','','1','0,1,');
INSERT INTO `cat` VALUES('6','','0','0,');
INSERT INTO `cat` VALUES('7','','0','0,');
INSERT INTO `cat` VALUES('8','','0','0,');
INSERT INTO `cat` VALUES('10','','6','0,6,');
INSERT INTO `cat` VALUES('11','','1','0,1,');
INSERT INTO `cat` VALUES('12','','1','0,1,');
INSERT INTO `cat` VALUES('14','','1','0,1,');
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 '2741' at line 1
======
DROP TABLE IF EXISTS a;
CREATE TABLE `a` (
`id` int(11) NOT NULL,
`uname` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `a` VALUES('1','a');
INSERT INTO `a` VALUES('2','a');
DROP TABLE IF EXISTS article;
CREATE TABLE `article` (
`aid` int(11) NOT NULL AUTO_INCREMENT,
`artid` int(11) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
`aname` varchar(25) DEFAULT NULL,
`piclink` varchar(50) DEFAULT NULL,
`artor` varchar(80) DEFAULT NULL,
`address` varchar(20) DEFAULT NULL,
`download` varchar(60) DEFAULT NULL,
`content` text,
`mname` varchar(20) DEFAULT NULL,
`click` int(11) DEFAULT NULL,
`status` varchar(20) DEFAULT NULL,
`atime` datetime DEFAULT NULL,
`mid` int(11) DEFAULT NULL,
`isdel` int(11) DEFAULT '0',
`istuangou` int(11) DEFAULT '0',
`artivityid` int(11) DEFAULT NULL,
`isjifen` int(11) DEFAULT '0',
`ispaimai` int(11) DEFAULT '0',
`isbao` int(11) DEFAULT '0',
`isyouhui` int(11) DEFAULT '0',
PRIMARY KEY (`aid`),
KEY `FK_ID` (`artid`),
KEY `FK_ID2` (`uid`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `article` VALUES('10','4','0','','5520ff21973fd.jpg','','','','','','200','','2015-04-05 00:00:00','1','0','0','0','0','0','0','0');
DROP TABLE IF EXISTS b;
CREATE TABLE `b` (
`id` int(11) NOT NULL,
`uname` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `b` VALUES('2','a');
INSERT INTO `b` VALUES('1','a');
DROP TABLE IF EXISTS bao;
CREATE TABLE `bao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`artname` varchar(255) DEFAULT NULL,
`starttime` int(11) DEFAULT NULL,
`endtime` int(11) DEFAULT NULL,
`upprice` int(11) DEFAULT NULL,
`downprice` int(11) DEFAULT '0',
`maxprice` int(11) DEFAULT '0',
`jifen` int(11) DEFAULT '1',
`instruction` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `bao` VALUES('1','','1428422400','1428508800','0','1','0','1','','0');
DROP TABLE IF EXISTS cat;
CREATE TABLE `cat` (
`mid` int(11) NOT NULL AUTO_INCREMENT,
`mname` varchar(30) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`path` varchar(50) DEFAULT NULL,
PRIMARY KEY (`mid`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `cat` VALUES('1','','0','0,');
INSERT INTO `cat` VALUES('4','','1','0,1,');
INSERT INTO `cat` VALUES('5','','1','0,1,');
INSERT INTO `cat` VALUES('6','','0','0,');
INSERT INTO `cat` VALUES('7','','0','0,');
INSERT INTO `cat` VALUES('8','','0','0,');
INSERT INTO `cat` VALUES('10','','6','0,6,');
INSERT INTO `cat` VALUES('11','','1','0,1,');
INSERT INTO `cat` VALUES('12','','1','0,1,');
INSERT INTO `cat` VALUES('14','','1','0,1,');
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 '2741' at line 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货