56,677
社区成员
发帖
与我相关
我的任务
分享
ALTER TABLE `order` ADD FOREIGN KEY (`userID`) REFERENCES `user`(`id`)
报错啊!这是怎么回事?
Query : ALTER TABLE 'order' ADD FOREIGN KEY ('userId') REFERENCES 'user'('id')
Error Code : 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 ''order' ADD FOREIGN KEY ('userId') REFERENCES 'user'('id')' at line 1
ALTER TABLE order ADD FOREIGN KEY (userid) REFERENCES user(id)
ALTER TABLE `order` ADD FOREIGN KEY (`userID`) REFERENCES `user`(`id)