[FIXED] How to merge two tables that have the same schema into one, whith phpmyadmin

Issue

I have two tables that have the same schema (tab1 and tab2), I would like to know how to merge them into one table, in a way to append tab2 under tab1.

I use phpmyadmin with WAMP.

to sum up what i want:

tab1

+tab2

= tab3 (tab3 = tab1 U tab2)

thank's

Solution

To answer your first question, in phpMyAdmin, open tab2, Operations > Copy table, choose tab1, and select Data only.

If you really want a tab3, open tab1, Operations > Copy table (structure and data) to tab3, then open tab2, Operations > Copy table (data only) to tab3.

Answered By - Marc Delisle