· 9 years ago · Jan 30, 2017, 11:04 PM
1CREATE TABLE IF NOT EXISTS `rotef`.`users` (
2 `id` INT(11) NULL,
3 `name` VARCHAR(100) NULL,
4 `year` INT(11) NULL,
5 PRIMARY KEY (`id`))
6ENGINE = InnoDB;
7
8INSERT INTO `rotef`.`users` (`id`, `name`,`year`) VALUES (1,"john", 2016);
9INSERT INTO `rotef`.`users` (`id`, `name`,`year`) VALUES (2,"jim", 2016);
10INSERT INTO `rotef`.`users` (`id`, `name`,`year`) VALUES (3,"eric", 2014);
11INSERT INTO `rotef`.`users` (`id`, `name`,`year`) VALUES (4,"jesi", 2012);
12INSERT INTO `rotef`.`users` (`id`, `name`,`year`) VALUES (5,"jef", 2011);