insert into table_a (column_a, column_b) SELECT * FROM (SELECT '1234567' A, 'anz' B UNION SELECT '2234567', 'anz' UNION ....) tmp