Quick Search:
 
 mySQL: Fake Union Jump to:  
Category: >> mySQL >> Fake Union  

<< lastnext >>

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;
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org