database user:     imke
database password: xp7ut3WhqjZhU5sS
database prefix:   imke_

CREATE TABLE dogs(
  id INT AUTO_INCREMENT PRIMARY KEY,
  dogname VARCHAR(20),
  birthyear INT
);

INSERT INTO dogs (dogname, birthyear) VALUES ('Pluto', 1933);
INSERT INTO dogs (dogname, birthyear) VALUES ('Morgan', 1983);
INSERT INTO dogs (dogname, birthyear) VALUES ('Bumbo', 1953);
INSERT INTO dogs (dogname, birthyear) VALUES ('Symfony', 2003);


SELECT * FROM dogs;
SELECT * FROM dogs ORDER BY dogname;
SELECT * FROM dogs ORDER BY birthyear;
SELECT * FROM dogs WHERE birthyear < 1980;

UPDATE dogs SET dogname='Symphony' WHERE id=4;
DELETE FROM dogs WHERE id=4;

ALTER TABLE dogs ADD gender CHAR(1) DEFAULT 'F';

ALTER TABLE dogs DROP gender;
