Yes i review manual many times without success
-----Messaggio originale-----
Da: Rick Emery [mailto:[EMAIL PROTECTED]]
Inviato: mercoledý 13 marzo 2002 16.52
A: 'Riccardi Moreno'; Php List; Mysql List
Oggetto: RE: [PHP-DB] Delete problem


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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to