DROP TABLE IF EXISTS `kk_siteinfo_table`;
CREATE TABLE `kk_siteinfo_table` (
`id` int(11) unsigned NOT NULL auto_increment,
`cid` int(11) unsigned NOT NULL,
`name` varchar(60) not null,
`weburl` varchar(60) NOT NULL,
`title` varchar(100) NOT NULL,
`keyword` varchar(100) NOT NULL,
`desc` varchar(200) NOT NULL,
`address` varchar(100) NOT NULL,
`tel` varchar(12) NOT NULL,
`display` char(2) default '0',
`create_date` int(11) NOT NULL,
`register_date` int(11) NOT NULL,
`language` char(8) NOT NULL,
PRIMARY KEY (`id`),
KEY `cid` (`cid`),
KEY `name` (name(10)),
KEY `title` (title(10)),
KEY `keyword` (keyword(10)),
KEY `desc` (desc(10)),
KEY `language` (`language`),
KEY `create_date` (`create_date`)
)TYPE=MyISAM;
报错:
ERROR 1064 (42000): 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 'desc(10)),
KEY `language` (`language`),
KEY `create_date` (`create_date`)
)TYP' at line 20
