[03] IS THERE AN SQL PRIMER I CAN USE?

    MySQL conforms pretty much to SQL92.  There are many
    documents/tutorials/faqs available on the net .. besides that,
    its beyond the scope of the SDF FAQ to cover this.

    HOWEVER, here are a few quick commands to get your started!
    The best way to learn SQL is by using it.

    (SQL commands are in UPPER CASE, objects are in lowercase)

    CREATING A TABLE
    ----------------

    CREATE TABLE test (
    name VARCHAR (15),
    email VARCHAR (25),
    phone INT,
    ID INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (ID));

    DESCRIBING A TABLE
    ------------------

    DESC test;

    +-------+-------------+------+-----+---------+----------------+
    | Field | Type        | Null | Key | Default | Extra          |
    +-------+-------------+------+-----+---------+----------------+
    | name  | varchar(15) | YES  |     | NULL    |                |
    | email | varchar(25) | YES  |     | NULL    |                |
    | phone | int(11)     | YES  |     | NULL    |                |
    | ID    | int(11)     |      | PRI | NULL    | auto_increment |
    +-------+-------------+------+-----+---------+----------------+

    INSERTING A ROW INTO A TABLE
    ----------------------------

    INSERT INTO test VALUES
    ('Ted Uhlemann', '[email protected]', '5551212', NULL);

    SELECTING RECORDS FROM A TABLE
    ------------------------------

    SELECT * FROM test;

    +--------------+------------------------+---------+----+
    | name         | email                  | phone   | ID |
    +--------------+------------------------+---------+----+
    | Ted Uhlemann | [email protected]          | 5551212 |  1 |
    +--------------+------------------------+---------+----+

    DELETING A ROW FROM A TABLE
    ---------------------------

    DELETE FROM test;

    ALTER A TABLE
    -------------

    ALTER TABLE test RENAME friends;

    ALTER TABLE friends ADD birthday DATE;

    ALTER TABLE friends CHANGE name fullname VARCHAR (25);

    ALTER TABLE friends DROP name;

    UPDATING A ROW
    --------------

    UPDATE test SET email = '[email protected]';

    UPDATE friends SET birthday = '1978-06-16' WHERE id = '1';

    DROPPING A TABLE
    ----------------

    DROP TABLE friends;

    COPY DATA BETWEEN TABLES
    ------------------------

    INSERT IGNORE INTO wp2_posts SELECT * FROM wp_posts;