For each row in table A
-----Insert row in table B with data from table A

This is what Im trying with:

insert into A (col1, col2, col3) values (select col1 from B, blabla, blabla);

Obviously this doesnt work as the "select col1 from B" returns multiple values.

So how do i do this without triggers in mysql?

Thanks in advance.