Difference between revisions of "Well Formed SQL Statements"
Jump to navigation
Jump to search
(Created page with '== General == SQL statements can be read much easier, if they are well-formatted. Good formatting is achieved as follows: * align the SQL keywords to the right * make use of fi...') |
|||
| Line 10: | Line 10: | ||
* align values to the left | * align values to the left | ||
| − | |||
| − | + | == SELECT == | |
| − | === | + | === ORDER BY === |
| + | === GROUP BY === | ||
| − | == | + | == INSERT == |
| − | === DELETE === | + | == UPDATE == |
| + | |||
| + | == DELETE == | ||
| + | |||
| + | == JOIN == | ||
| + | |||
| + | === Sub SELECT === | ||
Revision as of 00:08, 26 April 2010
General
SQL statements can be read much easier, if they are well-formatted.
Good formatting is achieved as follows:
- align the SQL keywords to the right
- make use of field and table aliases
- use only one field per line
- align operators to the right
- align values to the left