At 4:08 PM +0100 11/22/01, Andy wrote:
>Hi there,
>
>I am trying to do a combination of SQL statements like described in a SQL
>bok. Is it possible, that mysql does not allow this syntax?

According to the MySQL Reference Manual, subselects are not supported.

>
>Thanx Andy
>
>Error:
>
>Occured during executing DELETE FROM test_user_interests WHERE user_id =
>(SELECT user_id FROM test_user WHERE user_name = 'herbert01') statement
>
>Error: 1064 You have an error in your SQL syntax near 'SELECT user_id FROM
>test_user WHERE user_name = 'herbert01') ' at line 3

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to