I’m a big believer in readability, and I love to write code that is easy to understand. Check out my newly-posted MySQL Style Guide which covers:
- Simple queries
- Complex queries
- Advanced queries
- Use table aliases sparingly and only when absolutely necessary (a few extra keystrokes now will save you hours of gazing at cryptic queries later)
- CAPITALIZE keywords religiously
- Whitespace and tabs are your friends!