Posted by Raqueeb Hassan on 09/28/60 11:32

> http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

Yes, as the manual says ....

With INSERT ... SELECT, you can quickly insert many rows into a table
from one or many tables.

For example:

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



--
Raqueeb Hassan
Bangladesh

[Back to original message]