List:General Discussion« Previous MessageNext Message »
From:Tõnu Samuel Date:June 30 1999 9:40pm
Subject:Re: Conditional deletes
View as plain text  
Robert Hazeltine wrote:

> Is there a way to do it in SQL with, say, IFNULL?  Or do I have to query
> the database before deleting the record(s)?

NO! You can issue DELETE anytime and nothing goes wrong if for example
database is empty at all or just your criteria was not met.

Do just like:

DELETE FROM table WHERE field=value


Conditional deletesRobert Hazeltine1 Jul
  • Re: Conditional deletesTõnu Samuel1 Jul