Merging Tables with MySQL Merging tables, called "joining" in MySQL terms, is done by using the MySQL command interface in phpMyAdmin to create a new table.

Jack Wallen explains how to add data into a MySQL table from the command line.

Fastest Way to Check if MYSQL Table Exists in PHP. Dynamic PHP pages give you the option to choose a MySQL table dynamically from which to query.

If I create an identical non-temporary table the on-disk data file is ~100MB (engine=myisam). I have tmp_table_size for MySQL set to 256MB and max_heap_table_size set to 512MB.

Jack Wallen walks you through the process of enabling configuration storage for phpMyAdmin to gain added security features for the web-based MySQL tool.