Difference between revisions of "Well Formed SQL Statements"

From database24
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...')
(No difference)

Revision as of 00:06, 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

Examples

SELECT

INSERT

UPDATE

DELETE

Retrieved from "http://wiki.database24.net/index.php?title=Well_Formed_SQL_Statements&oldid=91"