mysql error number 1064?

Question

我写的语句是
ALTER TABLE `vshare`.`member` DROP PRIMARY KEY,
ADD PRIMARY KEY (`id`),
ADD CONSTRAINT `FK_member_cotegory` FOREIGN KEY `FK_member_cotegory` ()
REFERENCES `cotegory` ()
ON DELETE RESTRICT
ON UPDATE RESTRICT;
错误提示是：
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 ')
REFERENCES `cotegory` ()
ON DELETE RESTRICT
ON UPDATE RESTRICT' at line 3

Answer 1

主键字段 和 外键字段没有啊FK_member_cotegory` ()括号中是member外键字段，你这里是空的REFERENCES `cotegory` ()括号中是引用的主键表cotegory的主键字段，你这里是空的可达是要报错的啊 ,建议修改成 如下形式ALTER TABLE `vshare`.`member` DROP PRIMARY KEY,ADD PRIMARY KEY (`id`),ADD CONSTRAINT `FK_member_cotegory` FOREIGN KEY `FK_member_cotegory` (`cotegoryID`)REFERENCES `cotegory` (`ID`)ON DELETE RESTRICTON UPDATE RESTRICT;