DELETE
ALWAYS TYPE WHERE FIRST!
You should always do the following
- Test the where with a select
- Use transactions
- Select the result before committing the transaction
DELETE FROM SchemaName.TableName
WHERE Id = 10
ALWAYS TYPE WHERE FIRST!
You should always do the following
DELETE FROM SchemaName.TableName
WHERE Id = 10