CREATE TABLE total (
-> a INT NOT NULL AUTO_INCREMENT,
-> message CHAR(20), INDEX(a))
-> ENGINE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;
Newer used that, but looks like you have to state columns of that new table.
And you did not specify any.
anyway I would do something like this:
create table students_merged as select * from db1.students_contacts;
insert ignore into students_merged select * from db2.students_contacts;