Mysql更新表_删除表列，添加表主键自增语句——添加外键——删除外键索引

UPDATE wj_user SET valuecoin= 1000 WHEREid=11

ALTER TABLE sc ADD COLUMN id INT PRIMARY KEY AUTO_INCREMENT

ALTER TABLE sc DROP COLUMN id

ALTER TABLE sc ADD CONSTRAINT sid_fk FOREIGN KEY(sid) REFERENCES student(id)

ALTER TABLE sc ADD CONSTRAINT cid_fk FOREIGN KEY(cid) REFERENCES course(id) ON DELETE CASCADE ON UPDATE CASCADE

ALTER TABLE sc DROP FOREIGN KEY sid_fk