Mysql Insert Data From Select

insert A_table (id, name) select id,name from B_table;

Mysql Dump The Table Schema

mysqldump -u root -pmypassword test_database –no-data=true –add-drop-table=false > test_dump.sql

Mysql Dump Scheme

mysqldump -h… -u… -p… <DatabaseName> –no-data –triggers

This command will dump all table schemes in your database. Very useful!