Skip to main content

SQL

  • Always use ANSI mode for MySQL
  • Be careful with case sensitivity
  • Use snake_case for table and column names
  • Use UPPERCASE for SQL keywords
  • Always use unique, single-column primary keys
    • Multi-column primary keys are hard to work with, and most of the time you will eventually fall back to single-column primary keys
    • Start with auto-incrementing integer primary keys, expand to bigints or UUIDs if necessary

References​