0uuPv7Ym

1/* Prime Ministers database in MySQL. */
2
3create table if not exists people (
4  id int not null auto_increment primary key,
5  number int, /* 0 = subsequent term */
6  name varchar(40) not null,
7  gender char(1) not null,
8  dob date not null,
9  email varchar(40) not null,
10);
11
12/* Column names changed to avoid MySQL reserved words. */
13
14insert into people(number, name, gender, dob, email)
15values
16(1, 'Luke Smith', 'm', '10/23/1985', 'email1@email.com'),
17(2, 'Sarah Fisher', 'f', '10/23/1985', 'hotty@email.com'),
18(3, 'Chris Apple', 'm', '10/23/1985', 'guy@email.com'),
19
20/* Sample query to test insertion worked. */
21
22select * from people
23where true
24order by id;