Something similar is available using a FROM clause instead of a SELECT
clause, but it is only available in mysql 4.0.

Fred

Andy <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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?
>
> 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