MySQL Forums
Forum List  »  Newbie

Re: How to merge two or three different tables in one?
Posted by: Ron Mey-Ami
Date: September 07, 2008 08:38PM

You can do something like this (Note that respective columns must be of the same type)

INSERT INTO new_table
SELECT myColumn1, myColumn2,myColumn3
FROM old_table1
UNION
SELECT myColumn1, myColumn2,myColumn3
FROM old_table2
UNION
SELECT myColumn1, myColumn2,myColumn3
FROM old_table3;

Options: ReplyQuote


Subject
Written By
Posted
Re: How to merge two or three different tables in one?
September 07, 2008 08:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.