SQL Tools

SELECT

  1. SIMPLE COLUMNS

  2. SUMMARY COLUMNS AND VARIABLES

  3. WHERE CLAUSES

  4. JOINS: LEFT and RIGHT JOIN

  5. GROUP BY CLAUSE

  6. ORDER BY CLAUSE

  7. SUBQUERIES

  8. EXISTS

INSERT

    1. INSERT VALUES

    2. INSERT SELECT



UPDATE

      1. SINGLE ROW UPDATE

      2. MULTIPLE ROW UPDATE

      3. UPDATE ON JOIN

DELETE

        1. DELETE A ROW

        2. DELETE A SET OF ROWS

        3. USE OF EXISTS/SUBQUERIES

MEMORY VARIABLES

  1. SYSTEM

  2. USER DEFINED



CREATE TABLE SYNTAX

  1. CREATE TABLE

  2. CREATE TABLE (SELECT)



LOAD DATA SYNTAX