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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
