我寫(xiě)的語(yǔ)句是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 RESTRICTON UPDATE RESTRICT;錯(cuò)誤提示是：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 RESTRICTON UPDATE RESTRICT' at line 3
1 回答
寶慕林4294392
TA貢獻(xiàn)2021條經(jīng)驗(yàn) 獲得超8個(gè)贊
主鍵字段 和 外鍵字段沒(méi)有啊
FK_member_cotegory` ()括號(hào)中是member外鍵字段，你這里是空的
REFERENCES `cotegory` ()括號(hào)中是引用的主鍵表cotegory的主鍵字段，你這里是空的
可達(dá)是要報(bào)錯(cuò)的啊 ,建議修改成 如下形式
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 RESTRICT
ON UPDATE RESTRICT;
添加回答
舉報(bào)
0/150
提交
取消