Re: insert select problem
| From: | billy chan | Date: | Thu, 17 Apr 2003 08:52:35 +0000 |
| Subject: | Re: insert select problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27132@lists.php.net to get a copy of this message | ||
[Thu, 17 Apr 2003 09:23:59 +0200] Merlin <news.groups@web.de>
wrote:
> INSERT INTO changes
> SELECT
> (here comes the statement)
> , type = 1
I think you can do that with something like:
insert into changes
select a,b,c,1 as type from sometable