Question

建数据库表时出现这样的错误

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 ''15ú' at line
代码
DROP TABLE IF EXISTS `goodsinfo`;
CREATE TABLE `goodsinfo` (goodsinfogoodsinfo
`id` int(8) NOT NULL auto_increment,
`gname` varchar(30) default NULL,
`gaddress` varchar(50) default NULL,
`gtype` varchar(20) default NULL,
`ginfo` text,
`goodsid` int(10) default NULL,
`count` int(10) default NULL,
`price` varchar(10) default NULL,
`indate` varchar(20) default NULL,
`providerid` int(10) default NULL,
`admin` varchar(20) default NULL,
`status` varchar(2) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gbk;

Answer 1

goodsinfogoodsinfo,int(8),int(10)分别是什么？