Re: SQL: INSERT using subqueries

At 09:01 16.12.2002, Evan Nemerson said: --------------------[snip]-------------------- >Anyways, my question is rather simple- how do I do an INSERT using a >subquery? >I want something like this- only one that works: > >INSERT INTO myTable >SET owner=(SELECT id FROM users WHERE username='myUsername'); --------------------[snip]-------------------- INSERT INTO myTable SELECT id as "owner" FROM users where username='myUsername'; other columns, not selected from source table: INSERT INTO myTable SELECT id as "owner", 92 as "data1", 'hello world' as "data2" FROM users where username='myUsername'; should do it (untested on mySQL) -- >O Ernest E. Vogelsinger (\) ICQ #13394035 ^ http://www.vogelsinger.at/