Copy tables in MySQL

mysql_copyTables

# Drawn from http://stackoverflow.com/a/15649857/2016196

# To make a new table
CREATE TABLE YourNewTable
SELECT *
FROM mygrist_tables 
WHERE suic_att>=5 AND gender='M';

# To copy to an existing table
INSERT INTO YourNewTable 
SELECT * 
FROM mygrist_tables 
WHERE suic_att>=5 AND gender='M';