Actions

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