Re: insert select problem
| From: | Merlin | Date: | Thu, 17 Apr 2003 11:45:39 +0000 |
| Subject: | Re: insert select problem | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27144@lists.php.net to get a copy of this message | ||
thanx, that works
Merlin
"Billy Chan" <bilchan@dsim.net> schrieb im Newsbeitrag
news:MPG.1908ec3363550fa1989681@news.php.net...
> [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