DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(200) default NULL,
`author` varchar(200) default NULL,
`publishing` varchar(100) default NULL,
`number` varchar(100) default NULL,
`price` varchar(100) default NULL,
`storage` int(4) default NULL,
`brief` varchar(400) default NULL,
`type` int(4) default NULL,
`tate` int(4) default NULL,
`sums` int(4) NOT NULL default '0',
`imgpath` varchar(200) default NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
/*Table structure for table `tates` */
DROP TABLE IF EXISTS `tates`;
CREATE TABLE `tates` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(10) default NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `tates` */
------解决思路----------------------
你这个不是mssql吧,没有使用说明么?