delete all records except one?

ASP Free Forums Sponsor:

April 18th, 2004, 10:34 PM

Newton's Apple Wizard

Join Date: Nov 2003

Location: Los Angeles

Posts: 1,661

Time spent in forums: 3 Weeks 2 Days 2 h 39 m 22 sec
Reputation Power: 34

delete all records except one?

I am trying: DELETE FROM `countries` WHERE NOT countries_id = 223

What is wrong with it? I want to delete every record where countries_id is not 223

__________________
If you found a post of mine helpful, please click on the on my post to add to my reputation.

April 19th, 2004, 11:21 AM

Moderator: Access, SQL

Join Date: Oct 2003

Posts: 5,126

Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 13

DELETE * FROM countries WHERE countries_id <> 223

S-

April 19th, 2004, 11:27 AM

Newton's Apple Wizard

Join Date: Nov 2003

Location: Los Angeles

Posts: 1,661

Time spent in forums: 3 Weeks 2 Days 2 h 39 m 22 sec
Reputation Power: 34

thanks. that <> looked too ASPish to me so I didn't even try it. much appreciated.

Viewing: ASP Free Forums > Database > SQL Development > delete all records except one?

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump