mySQL: Fake Union - Alternate code for versions of mySQL that don't have the UNION function.

Quick Search:

mySQL: Fake Union

Jump to:

Category: >> mySQL >> Fake Union

<< last

next >>

Snippet Name: Fake Union

Description: Alternate code for versions of mySQL that don't have the UNION function.

Comment: (none)

Language: SQL
Highlight Mode: MYSQL
Last Modified: February 26th, 2009

CREATE TEMPORARY TABLE temp_union
 
     SELECT * FROM table_1;
 
     INSERT INTO temp_union
 
     SELECT * FROM table_2;
 
     SELECT * FROM temp_union;
 
DROP TABLE temp_union;