List:General Discussion« Previous MessageNext 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 deleteDario Hernan13 Nov
  • Re: Use select within deletemark addison13 Nov
    • Re: Use select within deleteRavi Kumar.14 Nov
      • Re: Use select within deleteDario Hernan14 Nov