gistfile1.txt

mysql> create table workouts 
    -> (
    -> id INT NOT NULL AUTO_INCREMENT,
    -> PRIMARY KEY (id),
    -> date DATETIME NOT NULL,
    -> reps INT NOT NULL,
    -> notes VARCHAR(200)
    -> );


cant type this syntax:
insert into workouts values (now(), 10, 'good workout');

have to declare columns:
insert into workouts (date, reps, notes) values (now(), 10, 'good workout');