insertar en los valores de seleccionar
INSERT IGNORE INTO my_table SELECT * FROM source_table;
INSERT IGNORE INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT IGNORE INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
WHERE s.my_col >= 10;
insertar seleccione
INSERT IGNORE INTO table2
SELECT * FROM table1
WHERE condition;
insertar pg resultado de seleccionar
insert into items_ver (item_id, name, item_group)
select item_id, name, item_group from items where item_id=2;