MySQL: Insert Result of Select query

You don’t need to use VALUES after INSERT INTO. Just use SELECT after INSERT INTO.

INSERT INTO
  table_name(col1, col2, ...)
SELECT
  col1, col2, ...
  FROM another_table_name;

Reference

• MySQL :: MySQL 5.7 Reference Manual :: 13.2.5.1 INSERT … SELECT Syntax

Load more