View Single Post
Old 08-18-2003, 05:09 PM  
KC
Confirmed User
 
Industry Role:
Join Date: Jan 1995
Posts: 2,417
Quote:
Originally posted by organic
delete from table_states where state = 'Aberdeenshire'

Drop is for deleting a table not an entry.
One other note...

Delete from [tablename];

without a where clause, will empty your entire table. Make sure you're really careful when deleting records.
__________________

Jupiter Hosting, Inc.
Vice President, Business Development
kc (AT) jupiterhosting.com

Last edited by KC; 08-18-2003 at 05:14 PM..
KC is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote