insert select problem
| From: | Merlin | Date: | Thu, 17 Apr 2003 07:23:59 +0000 |
| Subject: | insert select problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27131@lists.php.net to get a copy of this message | ||
Hi there,
I am facing a problem with the insert select syntax with mysql.
I do want to insert into a tmp table the values out of a querry and another
value:
INSERT INTO changes
SELECT
(here comes the statement)
, type = 1
I would simply like to add type to the results. Can this be that hard? The
statement above is wrong.
Thank you for any hint on that.
Merlin