Insira valores de selecionar statemtn

inserir em valores selecionar

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;