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, column2,
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