Home  |  Linux  | Mysql  | PHP  | XML
 
From:Chris Date:Thu May  8 17:59:43 2008
Subject:Re: mysql query and maximum characters in sql statement
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/
Navigate in group php.general at sever news.php.net
Previous Next




  
© No Copyright
You are free to use Anything 		Site Maintained by PHP Developer
Powered By PHP Consultants