Re: Load data and Insert
| From: | Torsten Roehr | Date: | Wed, 11 Aug 2004 15:09:39 +0000 |
| Subject: | Re: Load data and Insert | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-193453@lists.php.net to get a copy of this message | ||
"Torsten Roehr" <roehr@zilleon.com> wrote in message
news:20040811150349.86315.qmail@pb1.pair.com...
> "Juan Pablo Herrera" <juampi@linuxeducativo.com.ar> wrote in message
> &
> ivJZnews:1660.200.69.0.166.1092236555.squirrel@linuxeducativo.com.ar...
> > Hi!
> > i need do two querys in one.
> > First query is a load data and the second query is insert into.
> > My idea is to concatenate with "and", but i'not know.
> > Is it possible?
> >
> > Regards,
> > Juan
>
> Please specify a bit more clearly *what* data you want to load *from
where*
> and insert into *what*. Then we may be able to help you.
>
> Regards, Torsten Roehr
If you refer to MySQL you can use the INSERT ... SELECT syntax to do this in
one query. See here:
http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
Regards, Torsten Roehr