Replication between MySQL tables, with databases and different databases

MySQL's statement

We can first export the structure of the T1 table under test and create a new test1.t1 table.

Execute the following statement

INSERT INTO TEST1.T1 select * from Test.t1 limit 2 (limit bar number)

If you are in a database that is

INSERT INTO T1 SELECT * from T2 limit 2

If the table structure is not the same two tables, you can consider, and refer to the following statement

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_id from   Db_ds.t_stu_info as Stu     , db_ds.t_p_person_info as Person     

What, da?

INSERT INTO TEST1.T1 select * from TEST.T1 limit 2

Replication between MySQL tables, with databases and different databases