Database 101
From kemiko
- Always do a "select" before a "delete"
- Rename objects before deleting
- Always use a "where" clause..."where 1" or "where 1 = 1" for all queryies or add a comment to make it clear that the query is selecting everything
- Self joins can be handy
- Use ANSI joins for clarity
- Format SQL to for consistency and readability