daniel,
Thursday, July 11, 2002, 3:37:07 AM, you wrote:
d> why is it that this doens't work?
Because your syntax is wrong. If you want to use INSERT .. SELECT
statement, please, look at the manual for correct syntax:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
d> INSERT INTO myta
MySQL, as of yet, doesn't support sub-selects !
-Message d'origine-
De : daniel [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 11 juillet 2002 02:37
À : [EMAIL PROTECTED]
Objet : subselect in an insert
why is it that this doens't work?
INSERT INTO mytable (column0, column1, c
why is it that this doens't work?
INSERT INTO mytable (column0, column1, column2, column3, column4) values
($value0, (SELECT id from othertable where login='$ENV{REMOTE_USER}'),
$value2, $value3, $value4)";
the error i'm getting says that there's an error in my sql syntax near
'select id from ot
