insert select problem

"Merlin" <news.groups@web.de> · Thu, 17 Apr 2003 09:23:59 +0200

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php