删除外键字段删不掉,需要先drop掉外键约束:
ALTER TABLE paper DROP FOREIGN KEY fk_paper_stage_id;
ALTER TABLE paper DROP FOREIGN KEY fk_paper_subject_id;
然后就可以删除了
插入新的column:
alter table learn_order add column uid varchar(50) default null after tp;
修改column:
alter table learn_order modify column tp varchar(10) default null;
删除记录时如果遇到外键约束, 删不掉的话, 用下面的语句:
ALTER TABLE tk_knowhows
DROP FOREIGN KEY fk_tk_knowhows_tk_word_id;
然后再加上:
ALTER TABLE tk_knowhows
ADD CONSTRAINT fk_tk_knowhows_tk_word_id FOREIGN KEY (tk_word_id)
REFERENCES tk_words (id);
mysql -u root -p
从bash执行sql文件:
mysql -u user -p < db.sql
备份和恢复数据库:
https://linuxize.com/post/how-to-back-up-and-restore-mysql-databases-with-mysqldump/
删除数据:
delete from talbename;
ALTER TABLE mytable AUTO_INCREMENT = 1
导出某个表的内容:
mysqldump -u root -p problems_files bs_exam > bs_exam1.sql