mysql建表语句的问题 报错 error 1064 syntax

Question

[SQL]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(512) comment '描述',
'product_icon' varchar(512) comment '小图',
'category_type' int not null comment '类目编号',
'create_time' timestamp not null default current_timestamp comment '创建时间',
'update_time' timestamp not null default current_timestamp on update current_timestamp comment '修改时间',

) comment '商品表';
[Err] 1064 - 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 ''product_info' (
'product_id' varchar(32) not null,
'product' at line 1

        请问这个哪里出问题了

Answer 1

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(512) comment '描述',
product_icon varchar(512) comment '小图',
category_type int not null comment '类目编号',
create_time timestamp not null default current_timestamp comment '创建时间',
update_time timestamp not null default current_timestamp on update current_timestamp comment '修改时间',
PRIMARY KEY (product_id)
) comment '商品表';