I have two tables with exactly same structure (same fields: id, title, content). I want to merge/combine them. I used the following SQL:
CREATE TABLE total (id INT AUTO_INCREMENT PRIMARY KEY, title varchar (200) NULL,
content text NULL,
)
TYPE=MERGE UNION=(table1,table2) INSERT_METHOD=LAST;
But it did not work! Seems that it stucks at INSERT_METHOD=LAST
I am wondering since the two tables may have duplicate id, so it may not work. So what is the easiest way to merge two tables?
Thanks for your help!