RE: [PHP] Load data and Insert
| From: | Jay Blanchard | Date: | Wed, 11 Aug 2004 15:04:17 +0000 |
| Subject: | RE: [PHP] Load data and Insert | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193452@lists.php.net to get a copy of this message | ||
[snip]
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?
[/snip]
a. It is possible. http://catb.org/~esr/faqs/smart-questions.html
2. This is a PHP list, not a SQL list.
III. HTH!
INSERT INTO
table1
SELECT * FROM table2
You can use conditions, the number of columns must match.
http://dev.mysql.com/doc/mysql/en/INSERT.html