SQL statement Specification

Defined:

SQL is an abbreviation for Structured query Language (Structured Query language). SQL is a set of operational commands built for the database and is a fully functional database language.

Characteristics:

1. In the database system, SQL statements are case-insensitive (uppercase is recommended). However, string constants are case-sensitive. Recommended command uppercase, table name Library name lowercase;

2. SQL statements can be written in single or multiple lines, with ";" End. Keywords cannot span multiple lines or abbreviations.

3. Use space and indentation to improve the readability of the statement. Clauses are usually located on separate lines, making editing easier and more readable.

4, note: single-line Comment:--

Multi-line Comment:/*......*/

5, the SQL statement can be broken line operation

SQL statement Specification