Copy data from one table to another table in mysql

Copy data from one table to another table in mysql with where condition
“INSERT INTO TABLE2  SELECT * TABLE1 where status = ‘active’ ”

You can directly insert data into second table copy fro first table.