Combination of SQL statements invalid in MySQL?
| From: | Andy | Date: | Thu, 22 Nov 2001 15:08:40 +0000 |
| Subject: | Combination of SQL statements invalid in MySQL? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14532@lists.php.net to get a copy of this message | ||
Hi there,
I am trying to do a combination of SQL statements like described in a SQL
bóok. 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