mysql数据库创建表出错_mysql数据库建表语句错误

老是提示我第二行有错误我总觉得好像错在第一行不知道哪错了mysql5.5.36CREATETABLEIFNOTEXISTSgoods('goods_id'int(10)unsignedNOTNULLAUTO_INCREMENT,'goods_sn'char(15)notnulldef...

老是提示我第二行有错误 我总觉得好像错在第一行 不知道哪错了 mysql 5.5.36

CREATE TABLE IF NOT EXISTS goods(

'goods_id' int(10) unsigned NOT NULL AUTO_INCREMENT,

'goods_sn' char(15) not null default '',

'cat_id' smallint(6) not null default '0',

'brand_id' smallint(6) not nul default '0',

'goods_name' varchar(30) not null default '',

'shop_price' decimal(9,2) not null default '0.00',

'market_price' decimal(9,2) not null default '0.00',

'goods_number' smallint(6) not null default '1',

'click_count' mediumint(9) not null default '0',

'goods_weight' decimal(6,3) not null default '0.000',

'goods_brief' varchar(100) not null default '',

'goods_desc' text not null,

'thumb_img' varchar(30) not null default '',

'goods_img' varchar(30) not null default '',

'ori_img' varchar(30) not null default '',

'is_on_sale' tinyint(4) not null default '1',

'is_delete' tinyint(4) not null default '0',

'is_best' tinyint(4) not null default '0',

'is_new' tinyint(4) not null default '0',

'is_hot' tinyint(4) not null default '0',

'add_time' int(10) unsigned not null default '0',

'last_updata' int(10) unsigned not null default '0',

parimary key ('goods_id'),

unique key 'goods_sn' ('goods_sn')

) engine=mysiam default charset=utf8;

展开