How do I insert multiple rows in MySQL using nested select statements?
e.g. insert into lmms.household (id,family_name,location_id,last_update_time,last_update_user_id,creation_time,creation_user_id) values
((select households_id from world.households),(select family_name from world.households),"93469603",(select last_updated from world.households),"1",(select created_date from world.households),"1");
returns an error- "subquery returns more than one row"?
How can this statement be re-written?
select households_id from world.households
select family_name from world.households
select last_updated from world.households
those statements need to be 1 row.
just put a conditional like where whatever = whatever