Merge 2 Tables from different databases under the same user
Hi guys, I am stucked here... I need help please..
I dont know why I am getting this error, I think this morning i ran this query without errors and it worked.. I am trying to merge two different tables from two different databases under the same user into one table, the tables have the same fields, but different values, and I want a big table with the fields from the 2 merged tables.
I am using:
CREATE TABLE students_merged engine = MERGE UNION = (db1.students_contacts,db2.students_contacts);
And i get
"#1113 - A table must have at least 1 column " :mad:
Do you know what I am doing wrong, please?