INSERT INTO...SELECT for all MySQL columns - Stack Overflow

For the syntax , it looks like this (leave out the column list to implicitly mean "all") INSERT INTO this_table_archive SELECT * FROM this_table WHERE ...

stackoverflow.com