MySQL Lists: mysql: Use select within delete

List:	General Discussion	« Previous Message Next Message »
From:	Dario Hernan	Date:	November 13 2007 1:50pm
Subject:	Use select within delete
View as plain text

Hi all I need to delete some fields from a table but in the where
clause I need to put a select command.
For instance, delete from table1 where id=(select id from table2 where
date<oneweek)
Is it possible in mysql 4.0.24??

Thanks in advance
Dario

Thread
• Use select within delete	Dario Hernan	13 Nov
• Re: Use select within delete	mark addison	13 Nov
• Re: Use select within delete	Ravi Kumar.	14 Nov
• Re: Use select within delete	Dario Hernan	14 Nov