Skip to content

Latest commit

 

History

History
12 lines (8 loc) · 575 Bytes

mysql-style-guide.md

File metadata and controls

12 lines (8 loc) · 575 Bytes

SQL Style Guide

SQL Style guide to design standard database and query by Simon Holywell. https://www.sqlstyle.guide/. https://raw.githubusercontent.com/treffynnon/sqlstyle.guide/gh-pages/_includes/sqlstyle.guide.md

General

Do

  • Use consistent and descriptive identifiers and names
  • Make judicious use of white space and indentation to make code easier to read.
  • Store [ISO 8601][iso-8601] compliant time and date information (YYYY-MM-DD HH:MM:SS.SSSSS).
  • Try to only use standard SQL funtions instead of vendor-specific functions for reasons of portability