Re: [PHP] mysql query and maximum characters in sql statement

[email protected] (Chris)
Newsgroups php.general
Message-ID <[email protected]>
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/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.