[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