Mysql 表之间数据迁移
更新于
2022-05-04 00:46
156
标签：
mysql
1.相同表结构
INSERT INTO table1 SELECT * FROM table2;
2.不同表结构
INSERT INTO table1(filed1,...,filedn) SELECT table2.filed1,...,table2.filedn FROM table2;
3.如果是不同数据库之间，参考以下：
INSERT into db_ds_edu.t_exam_student(stu_id,stu_number,stu_name,school_id,campus_id,grade_id,class_id,xuebu_id)SELECT stu.id, stu.student_num,person.name, stu.school_id, stu.campus_id, stu.grade_id, stu.clas_id, stu.xuebu_idFROMdb_ds.t_stu_info AS stu,db_ds.t_p_person_info as personWHERE stu.person_id = person.id
