List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 20 1999 8:31pm
Subject:Re: Multiple Deleting?
View as plain text  
On Sat, 1999-08-21 00:53:34 -0700, Mick Hanna wrote:
> What would the delete statement be given that i will retrieve the
> values of each row by id number?
> id=1234......

  DELETE FROM tablename WHERE id=1234 OR id=1235 OR ...;

Or better:

  DELETE FROM tablename WHERE id IN (1234, 1235, ...);

Is this what you wanted to know?

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
Multiple Deleting?Mick Hanna20 Aug
  • Re: Multiple Deleting?Martin Ramsch20 Aug
Re: Multiple Deleting?PinkeshP20 Aug