CODE EXAMPLE FOR SQL

multi row insert

insert into bricks (brick_id, colour)
  select toy_id, colour
  from   toys
  where  toy_id in ( 4, 5 );

select * from bricks
where  brick_id in ( 4, 5 );