mysql数据库给表增加外键

91 阅读1分钟

ALTER TABLE user ADD CONSTRAINT FK_Name FOREIGN KEY (bts_id) REFERENCES student(ID);

给user表的bts_id字段增加名字叫Fk_Name的外键,外键是student表里的Id;