Re: mysql query and maximum characters in sql statement
| From: | Chris | Date: | Thu, 08 May 2008 23:59:43 +0000 |
| Subject: | Re: mysql query and maximum characters in sql statement | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-274042@lists.php.net to get a copy of this message | ||
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/