mysql

建表语句

1、先建data seller，再建表

2、colName 要用反引号，comment要用单引号

 

create table `product_info`(
`product_id` varchar(32) not null,
`product_name` varchar(64) not null comment `商品名称`,
`product_price` decimal(8,2) not null comment `单价`,
`product_stock` int not null comment `库存`,
`product_description` varchar(64) not null comment `描述`,
`product_icon` varchar(64) not null comment `小图`,
`product_type` int not null comment `类目编号`,
`create_time` timestamp not null default current_timestamp comment `创建时间`,
primary key (`product_id`)

) coomment `商品表`;