Usa INSERT ... SELECT: http://dev.mysql.com/doc/mysql/en/insert-select.html