<div>
<a href="http://www.w3schools.com/sql/sql_select_into.asp" rel="ugc">http://www.w3schools.com/sql/sql_select_into.asp</a>
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have tree tables (table1, table2, table3). All of this tables have exacly the same fields.<br />
I neeed a mysql query &nbsp;to create a table (total) from the union of this 3 tables!<br />
<br />
Thank you!
</div>
</div>


Hi,

I have tree tables (table1, table2, table3). All of this tables have exacly the same fields.
I neeed a mysql query  to create a table (total) from the union of this 3 tables!

Thank you!

http://www.w3schools.com/sql/sql_select_into.asp

Make table from a union query

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.