· 9 years ago · Dec 21, 2016, 11:04 AM
1CREATE TABLE IF NOT EXISTS `clients` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `first_name` varchar(100) DEFAULT NULL,
4 `last_name` varchar(100) DEFAULT NULL,
5 `email` varchar(100) DEFAULT NULL,
6 `gender` enum('M','F') DEFAULT NULL,
7 `created_at` datetime DEFAULT NULL,
8 `updated_at` datetime DEFAULT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
11
12INSERT INTO `clients` (`id`, `first_name`, `last_name`, `email`, `gender`, `created_at`, `updated_at`) VALUES
13 (1, 'Samuel', 'Coleman', 'scoleman0@baidu.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
14 (2, 'Adam', 'Riley', 'ariley1@irs.gov', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
15 (3, 'Joan', 'Vasquez', 'jvasquez2@hibu.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
16 (4, 'David', 'Nichols', 'dnichols3@skyrock.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
17 (5, 'Ryan', 'Warren', 'rwarren4@youku.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
18 (6, 'Maria', 'Anderson', 'manderson5@w3.org', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
19 (7, 'Willie', 'Pierce', 'wpierce6@google.it', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
20 (8, 'Harold', 'Garcia', 'hgarcia7@hhs.gov', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
21 (9, 'Nicholas', 'Washington', 'nwashington8@google.com.hk', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
22 (10, 'Laura', 'Jenkins', 'ljenkins9@alexa.com', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
23 (11, 'Louis', 'Little', 'llittlea@accuweather.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
24 (12, 'George', 'Bradley', 'gbradleyb@omniture.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
25 (13, 'Roger', 'Thomas', 'rthomasc@furl.net', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
26 (14, 'Marie', 'Woods', 'mwoodsd@boston.com', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
27 (15, 'Sharon', 'Gonzalez', 'sgonzaleze@mapquest.com', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21');