Actions

Difference between revisions of "Database 101"

From kemiko

(Created page with "* Always do a "select" before a "delete" * Rename objects before deleting * Always use a "where" clause..."where 1" or "where 1 = 1" for all * Self joins can be handy * Use AN...")
(No difference)

Revision as of 22:10, 25 August 2017

  • Always do a "select" before a "delete"
  • Rename objects before deleting
  • Always use a "where" clause..."where 1" or "where 1 = 1" for all
  • Self joins can be handy
  • Use ANSI joins for clarity