Posted by Raqueeb Hassan on 11/04/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

• Next in forum: Re: Returning NULL vs. returning FALSE
• Prev in forum: Re: No more access to characters in strings in PHP 6?
• Thread view: Re: mysql query to create a new table from existing fields

[Reply to this message]