insertar con select

[Ursulo]

Aqui un ejemplo,

INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

y aqui la pagina

http://dev.mysql.com/doc/refman/5.0/...rt-select.html