Sanjeev N wrote:
> Hi Jim Lucas,
>
> You are correct... i want to run in the same way.
>
> but as my 2 tables, column name are different i cant run the LOAD DATA
> infile.

If you're inserting the same data, then use LOAD DATA INFILE to load it
into a temporary table, then use INSERT SELECT's to put them into the
other tables.

--
Postgresql & php tutorials
http://www.designmagick.com/