mysql - How Can I Combine a SELECT Statement that Returns Multiple Rows with an INSERT Statement? -

mysql - How Can I Combine a SELECT Statement that Returns Multiple Rows with an INSERT Statement? -

this returns multiple rows:

select field_one table_one field_two = value_three

i need results of statement go value_one in one:

insert table_one (field_one, field_two) values(value_one, value_two)

my question similar 1 (how can combine insert , select mysql statement?) except select statement homecoming multiple rows.

insert table_one (field_one, field_two) select field_one, value_two table_one field_two = value_three

mysql sql sql-insert