MySQL 2/13

action          subject     adjectives/conditions
[SELECT * FROM]     [title]     [WHERE title LIKE '%a%']

CREATE DATABASE pubs;
INSERT INTO title(col1, col2) VALUES (val1, val2)

//inserting something will put it into a new row. if row 2 is deleted, and you insert something to the table, it does not go to that empty row

INSERT INTO author(name, address, contract)
SELECT DISTINCT author_name FROM

//select allows selection of rows and columns
// use asterisk wildcard (*) to select ALL

SELECT title
FROM title
WHERE (title LIKE

ORDER BY price DESC <--if you want it to be sorted in descending manner
    default is ASCENDING sort
    ORDER BY always comes after WHERE