thanx, that works Merlin "Billy Chan" <bilchan@dsim.net> schrieb im Newsbeitrag MPG.1908ec3363550fa1989681@news.php.net">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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
