MySQL does not currently support sub-selects.
The manual says:
DELETE [LOW_PRIORITY | QUICK] FROM table_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]
Did you review the manual first?
-----Original Message-----
From: Riccardi Moreno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 9:48 AM
To: Php List; Mysql List
Subject: [PHP-DB] Delete problem
Hi all,
I'm trying to delete records with this query on php program:
delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
ID_GROUP = '$group')
I use it on MSSQL and work fine but on mysql don't work, there's some other
query that make the same result on mysql
Thank's all
--------------------------------------------
- Moreno Riccardi
- www.webtrade.it
--------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
