自己做了个安装文件,自动生成一些数据库代码,使用中总是报错看了一下生成的文件: CREATE TABLE yc_accessor (
`ID` int(32) unsigned NOT NULL auto_increment ,
`group_id` int(10) unsigned NOT NULL ,
`text_id` varchar(32) NOT NULL ,
`visitor` varchar(64) NOT NULL ,
`url_ip` varchar(64) NOT NULL ,
`url_self` varchar(128) NOT NULL ,
`url_previous` varchar(128) NOT NULL ,
`operate` varchar(64) NOT NULL ,
`re` text NOT NULL ,
`createtime` timestamp NOT NULL ,
,
KEY `ID` (`ID`)
) ;
将字段名两边的引号去掉也报错:#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 '
KEY `ID` (`ID`)
发一段正确可运行的:
CREATE TABLE IF NOT EXISTS `yc_accessor` (
`ID` int(32) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`group_id` int(10) unsigned COMMENT '组id',
`text_id` varchar(32) COMMENT '文章序号',
`visitor` varchar(64) COMMENT '访问者',
`url_ip` varchar(64) COMMENT '访问者ip',
`url_self` varchar(64) COMMENT '被访问页面',
`url_previous` varchar(64) COMMENT '访问者来源',
`operate` varchar(128) COMMENT '操作记录
`re` text COMMENT '备注',
`datetime` timestamp NULL COMMENT '访问日期',
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='访问记录' AUTO_INCREMENT=1 ;
小弟眼拙,实在看不出什么差别(表名车加上引号、去掉引号,不管怎么弄错误还是出现)
`ID` int(32) unsigned NOT NULL auto_increment ,
`group_id` int(10) unsigned NOT NULL ,
`text_id` varchar(32) NOT NULL ,
`visitor` varchar(64) NOT NULL ,
`url_ip` varchar(64) NOT NULL ,
`url_self` varchar(128) NOT NULL ,
`url_previous` varchar(128) NOT NULL ,
`operate` varchar(64) NOT NULL ,
`re` text NOT NULL ,
`createtime` timestamp NOT NULL ,
,
KEY `ID` (`ID`)
) ;
将字段名两边的引号去掉也报错:#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 '
KEY `ID` (`ID`)
发一段正确可运行的:
CREATE TABLE IF NOT EXISTS `yc_accessor` (
`ID` int(32) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
`group_id` int(10) unsigned COMMENT '组id',
`text_id` varchar(32) COMMENT '文章序号',
`visitor` varchar(64) COMMENT '访问者',
`url_ip` varchar(64) COMMENT '访问者ip',
`url_self` varchar(64) COMMENT '被访问页面',
`url_previous` varchar(64) COMMENT '访问者来源',
`operate` varchar(128) COMMENT '操作记录
`re` text COMMENT '备注',
`datetime` timestamp NULL COMMENT '访问日期',
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='访问记录' AUTO_INCREMENT=1 ;
小弟眼拙,实在看不出什么差别(表名车加上引号、去掉引号,不管怎么弄错误还是出现)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货