【错误】

create table `tb_shop`(
`shop_id` int(10) not null auto_increment,
`owner_id` int(10) not null comment '店铺创建人',
`area_id` int(5) default null,
`shop_category_id` int(11) default null,
`shop_name` varchar(256) not null,
`shop_desc` varchar(1024) default null,
`shop_addr` varchar(200) default null,
`phone` varchar(128) default null,
`shop_img` varchar(1024) default null,
`priority` int(3) default '0',
`create_time` datetime default null,
`last_edit_time` date default null,
`enable_status` int(2) not null default'0',
`advice` varchar(255) default null,
PRIMARY KEY(`shop_id`),
CONSTRAINT `fk_shop_area` FOREIGN KEY(`area_id`) REFERENCES `tb_area`(`area_id`),
CONSTRAINT `fk_shop_profile` FOREIGN KEY(`owner_id`) REFERENCES `tb_person_info`(`user_id`),
CONSTRAINT `fk_shop_shopcate` FOREIGN KEY(`shop_category_id`) REFERENCES `tb_shop_category(`shop_category_id`)
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8

报错

[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 'shop_category_id`)
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8' at line 19

 

posted @ 2022-04-26 00:55  你好,Alf  阅读(5)  评论(0编辑  收藏  举报