在做一个PHPCMS 团购插件,问题怎么解决呐,是mysql数据库的;搞了好长时间了呐~!
MySQL Query : CREATE TABLE `v9_tuan_api` ( `web_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `api_url` varchar(255) NOT NULL DEFAULT '', `web_title` varchar(50) NOT NULL DEFAULT '', `web_url` varchar(255) NOT NULL DEFAULT '', `web_sh` tinyint(1) unsigned NOT NULL DEFAULT '0', `show_sh` tinyint(1) unsigned NOT NULL DEFAULT '0', `body` varchar(50) NOT NULL DEFAULT '', `loc` varchar(50) NOT NULL DEFAULT '', `website` varchar(50) NOT NULL DEFAULT '', `siteurl` varchar(50) NOT NULL DEFAULT '', `city` varchar(50) NOT NULL DEFAULT '', `category` varchar(50) NOT NULL DEFAULT '', `dopshopid` varchar(50) NOT NULL DEFAULT '', `range` varchar(50) NOT NULL DEFAULT '', `address` varchar(50) NOT NULL DEFAULT '', `major` varchar(50) NOT NULL DEFAULT '', `title` varchar(50) NOT NULL DEFAULT '', `image` varchar(50) NOT NULL DEFAULT '', `starttime` varchar(50) NOT NULL DEFAULT '', `endtime` varchar(50) NOT NULL DEFAULT '', `value` varchar(50) NOT NULL DEFAULT '', `price` varchar(50) NOT NULL DEFAULT '', `rebate` varchar(50) NOT NULL DEFAULT '', `bought` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`web_id`),) ENGINE=MyISAM DEFAULT CHARSET=gbk;
MySQL 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 ') ENGINE=MyISAM DEFAULT CHARSET=gbk' at line 1
MySQL Errno : 1064
Message : 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 ') ENGINE=MyISAM DEFAULT CHARSET=gbk' at line 1
Need Help?
CREATE TABLE `v9_tuan_api` (
`web_id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`api_url` VARCHAR(255) NOT NULL DEFAULT '',
`web_title` VARCHAR(50) NOT NULL DEFAULT '',
`web_url` VARCHAR(255) NOT NULL DEFAULT '',
`web_sh` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`show_sh` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`body` VARCHAR(50) NOT NULL DEFAULT '',
`loc` VARCHAR(50) NOT NULL DEFAULT '',
`website` VARCHAR(50) NOT NULL DEFAULT '',
`siteurl` VARCHAR(50) NOT NULL DEFAULT '',
`city` VARCHAR(50) NOT NULL DEFAULT '',
`category` VARCHAR(50) NOT NULL DEFAULT '',
`dopshopid` VARCHAR(50) NOT NULL DEFAULT '',
`range` VARCHAR(50) NOT NULL DEFAULT '',
`address` VARCHAR(50) NOT NULL DEFAULT '',
`major` VARCHAR(50) NOT NULL DEFAULT '',
`title` VARCHAR(50) NOT NULL DEFAULT '',
`image` VARCHAR(50) NOT NULL DEFAULT '',
`starttime` VARCHAR(50) NOT NULL DEFAULT '',
`endtime` VARCHAR(50) NOT NULL DEFAULT '',
`value` VARCHAR(50) NOT NULL DEFAULT '',
`price` VARCHAR(50) NOT NULL DEFAULT '',
`rebate` VARCHAR(50) NOT NULL DEFAULT '',
`bought` VARCHAR(50) NOT NULL DEFAULT '',
PRIMARY KEY (`web_id`)
)ENGINE=MYISAM DEFAULT CHARSET=gbk;。