/*
Navicat Premium Data Transfer
Source Server : 10.211.55.3
Source Server Type : MySQL
Source Server Version : 50527
Source Host : 10.211.55.3:3306
Source Schema : demo01
Target Server Type : MySQL
Target Server Version : 50527
File Encoding : 65001
Date: 26/04/2022 13:18:04
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of city
-- ----------------------------
BEGIN;
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (1, 'test1', 'city1', '2022-04-26');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (2, 'test2', 'city2', '2022-04-25');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (3, 'test3', 'city3', '2022-04-24');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (4, 'test4', 'city4', '2022-04-23');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (5, 'test5', 'city5', '2022-04-22');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (6, 'test6', 'city6', '2022-04-21');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (7, 'test7', 'city7', '2022-04-20');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (8, 'test8', 'city8', '2022-04-19');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (9, 'test9', 'city9', '2022-04-18');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (10, 'test10', 'city10', '2022-04-17');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (11, 'test11', 'city11', '2022-04-16');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (12, 'test12', 'city12', '2022-04-15');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (13, 'test13', 'city13', '2022-04-14');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (14, 'test14', 'city14', '2022-04-13');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (15, 'test15', 'city15', '2022-04-12');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (16, 'test16', 'city16', '2022-04-11');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (17, 'test17', 'city17', '2022-04-10');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (18, 'test18', 'city18', '2022-04-09');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (19, 'test19', 'city19', '2022-04-08');
INSERT INTO `city` (`id`, `name`, `address`, `date`) VALUES (20, 'test20', 'city20', '2022-04-07');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
评论10