每日必背
2018-08-08 本文已影响0人
EmptyBottl_520d
每日必备
#添加外键 先保证删除了 再添加
ALTER TABLE `student_info` DROP FOREIGN KEY `courseid`;
ALTER TABLE `student_info` ADD CONSTRAINT `courseid` FOREIGN KEY (`course_id`)
REFERENCES `course_info` (`course_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
LOCK TABLES `student_info` WRITE;
ulock tables；
