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.