· 5 years ago · Feb 24, 2020, 06:32 PM
1CREATE DATABASE IF NOT EXISTS `assignment-06`
2 DEFAULT CHARACTER SET utf8
3 COLLATE utf8_unicode_ci;
4
5CREATE TABLE IF NOT EXISTS `assignment-06`.`people` (
6 `person_id` INT(11) NOT NULL AUTO_INCREMENT,
7 `first_name` VARCHAR(80) DEFAULT NULL,
8 `last_name` VARCHAR(80) DEFAULT NULL,
9 `birth_date` DATETIME NOT NULL DEFAULT '2020-01-01 23:59:59',
10 PRIMARY KEY (`person_id`),
11 INDEX (`birth_date`)
12) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
13
14INSERT INTO `assignment-06`.`people`
15 (`first_name`, `last_name`, `birth_date`) VALUES
16 ('Robert', 'Downey Jr.', '1965-04-04 00:00:00'),
17 ('Chris', 'Evans', '1981-06-13 00:00:00'),
18 ('Mark', 'Ruffalo', '1967-11-22 00:00:00'),
19 ('Chris', 'Hemsworth', '1984-08-11 00:00:00'),
20 ('Scarlett', 'Johansson', '1984-11-22 00:00:00'),
21 ('Tom', 'Holland', '1996-06-01 00:00:00');