1
2
3
4
5
6
7
8
9
10
11
12
13
| USE todo;
| DROP TABLE IF EXISTS `Person`;
| CREATE TABLE `Person` (`id` BIGINT not null auto_increment primary key, `name` VARCHAR(40));
| INSERT INTO `Person` (`id`,`name`) VALUES (1,'John');
| INSERT INTO `Person` (`id`,`name`) VALUES (2,'Steve');
| INSERT INTO `Person` (`id`,`name`) VALUES (3,'Mark');
| INSERT INTO `Person` (`id`,`name`) VALUES (4,'Nick');
| INSERT INTO `Person` (`id`,`name`) VALUES (5,'Nita');
| INSERT INTO `Person` (`id`,`name`) VALUES (6,'John');
| INSERT INTO `Person` (`id`,`name`) VALUES (7,'Julia');
| INSERT INTO `Person` (`id`,`name`) VALUES (8,'Joe');
| INSERT INTO `Person` (`id`,`name`) VALUES (9,'Nita');
| INSERT INTO `Person` (`id`,`name`) VALUES (10,'Branden');
|
|