· 9 years ago · Dec 11, 2016, 09:24 PM
1SET NAMES utf8mb4;
2SET FOREIGN_KEY_CHECKS = 0;
3
4-- ----------------------------
5-- Table structure for `test_table`
6-- ----------------------------
7DROP TABLE IF EXISTS `test_table`;
8CREATE TABLE `test_table` (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `tanggal` date NOT NULL,
11 PRIMARY KEY (`id`)
12) ENGINE=InnoDB AUTO_INCREMENT=512 DEFAULT CHARSET=latin1;
13
14-- ----------------------------
15-- Records of `test_table`
16-- ----------------------------
17BEGIN;
18INSERT INTO `test_table` VALUES ('1', '2016-09-27'), ('2', '2016-09-24'), ('3', '2016-10-07'), ('4', '2017-01-20'), ('5', '2016-09-30'), ('6', '2016-10-03'), ('7', '2016-10-03'), ('8', '2017-12-28'), ('9', '2016-09-26'), ('10', '2016-10-12'), ('11', '2016-10-15'), ('12', '2016-09-27'), ('13', '2016-10-08'), ('14', '2016-09-26'), ('15', '2017-12-27'), ('16', '2016-09-26'), ('17', '2016-09-30'), ('18', '2016-10-10'), ('19', '2016-10-17'), ('20', '2016-09-28'), ('21', '2016-09-27'), ('22', '2016-10-05'), ('23', '2016-10-15'), ('24', '2016-10-18'), ('25', '2016-09-28'), ('26', '2016-09-27'), ('27', '2016-09-26'), ('28', '2016-09-29'), ('29', '2016-09-30'), ('30', '2016-09-30'), ('31', '2016-09-29'), ('32', '2016-10-11'), ('33', '2016-09-30'), ('34', '2016-12-09'), ('35', '2016-11-10'), ('36', '2016-11-23'), ('37', '2016-10-28'), ('38', '2016-10-31'), ('39', '2016-11-29'), ('40', '2016-11-02'), ('41', '2016-10-28'), ('42', '2016-10-29'), ('43', '2016-11-02'), ('44', '2016-11-02'), ('45', '2016-11-03'), ('46', '2016-10-14'), ('47', '2016-10-27'), ('48', '2016-10-29'), ('49', '2016-09-30'), ('50', '2016-10-23'), ('51', '2016-09-30'), ('52', '2016-09-29'), ('53', '2016-09-29'), ('54', '2016-11-24'), ('55', '2016-10-05'), ('56', '2016-10-07'), ('57', '2016-10-07'), ('58', '2016-10-05'), ('59', '2016-10-06'), ('60', '2016-10-08'), ('61', '2016-10-05'), ('62', '2016-10-03'), ('63', '2016-09-29'), ('64', '2016-09-30'), ('65', '2016-09-30'), ('66', '2016-10-17'), ('67', '2016-09-30'), ('68', '2016-11-21'), ('69', '2016-10-25'), ('70', '2016-09-30'), ('71', '2016-09-30'), ('72', '2016-10-15'), ('73', '2016-10-21'), ('74', '2016-11-07'), ('75', '2016-10-08'), ('76', '2016-10-27'), ('77', '2016-10-08'), ('78', '2016-10-06'), ('79', '2016-10-20'), ('80', '2016-12-05'), ('81', '2016-10-04'), ('82', '2016-10-07'), ('83', '2016-10-07'), ('84', '2016-10-21'), ('85', '2016-10-08'), ('86', '2016-10-21'), ('87', '2016-10-24'), ('88', '2016-11-02'), ('89', '2016-10-05'), ('90', '2016-10-05'), ('91', '2016-11-07'), ('92', '2016-10-13'), ('93', '2016-10-10'), ('94', '2016-10-19'), ('95', '2016-10-07'), ('96', '2016-11-02'), ('97', '2016-11-25'), ('98', '2016-10-22'), ('99', '2016-11-30'), ('100', '2016-10-14'), ('101', '2016-10-14'), ('102', '2016-10-18'), ('103', '2016-10-05'), ('104', '2016-11-23'), ('105', '2016-10-10'), ('106', '2016-10-13'), ('107', '2016-10-07'), ('108', '2016-11-18'), ('109', '2016-11-07'), ('110', '2016-11-09'), ('111', '2016-10-13'), ('112', '2016-11-12'), ('113', '2016-12-09'), ('114', '2016-10-07'), ('115', '2016-10-07'), ('116', '2016-10-25'), ('117', '2016-10-29'), ('118', '2016-10-08'), ('119', '2016-10-07'), ('120', '2016-10-08'), ('121', '2016-11-09'), ('122', '2016-10-18'), ('123', '2016-11-30'), ('124', '2016-10-14'), ('125', '2016-10-11'), ('126', '2016-11-12'), ('127', '2016-10-17'), ('128', '2016-10-19'), ('129', '2016-10-13'), ('130', '2016-10-14'), ('131', '2016-12-08'), ('132', '2016-11-02'), ('133', '2016-11-18'), ('134', '2016-10-28'), ('135', '2016-11-14'), ('136', '2016-10-10'), ('137', '2016-10-23'), ('138', '2016-10-12'), ('139', '2016-10-12'), ('140', '2016-10-12'), ('141', '2016-10-21'), ('142', '2016-11-04'), ('143', '2016-10-20'), ('144', '2016-10-17'), ('145', '2016-11-22'), ('146', '2016-10-15'), ('147', '2016-10-20'), ('148', '2016-10-02'), ('149', '2016-10-13'), ('150', '2016-10-18'), ('151', '2016-11-08'), ('152', '2016-10-14'), ('153', '2016-10-12'), ('154', '2016-11-30'), ('155', '2016-11-23'), ('156', '2016-10-31'), ('157', '2016-11-05'), ('158', '2016-10-14'), ('159', '2016-10-31'), ('160', '2016-10-12'), ('161', '2016-11-01'), ('162', '2016-11-15'), ('163', '2016-10-13'), ('164', '2016-11-12'), ('165', '2016-10-20'), ('166', '2016-11-08'), ('167', '2016-11-14'), ('168', '2016-10-29'), ('169', '2016-11-29'), ('170', '2016-10-19'), ('171', '2016-10-29'), ('172', '2016-10-15'), ('173', '2016-11-18'), ('174', '2016-10-18'), ('175', '2016-10-18'), ('176', '2016-10-19'), ('177', '2016-11-11'), ('178', '2016-11-19'), ('179', '2016-10-31'), ('180', '2016-12-01'), ('181', '2016-10-19'), ('182', '2016-12-26'), ('183', '2016-11-02'), ('184', '2016-10-25'), ('185', '2016-11-05'), ('186', '2016-11-21'), ('187', '2016-10-31'), ('188', '2016-10-22'), ('189', '2016-10-19'), ('190', '2016-10-29'), ('191', '2016-10-25'), ('192', '2016-10-19'), ('193', '2016-10-20'), ('194', '2016-12-01'), ('195', '2016-12-08'), ('196', '2016-12-08'), ('197', '2016-11-17'), ('198', '2016-10-25'), ('199', '2016-11-24'), ('200', '2016-12-03'), ('201', '2016-11-14'), ('202', '2016-11-10'), ('203', '2016-10-25'), ('204', '2016-10-26'), ('205', '2016-11-15'), ('206', '2016-11-05'), ('207', '2016-10-23'), ('208', '2016-10-21'), ('209', '2016-11-24'), ('210', '2016-10-31'), ('211', '2016-10-31'), ('212', '2016-11-05'), ('213', '2016-10-21'), ('214', '2016-11-03'), ('215', '2016-11-16'), ('216', '2016-11-28'), ('217', '2016-10-22'), ('218', '2016-12-07'), ('219', '2016-10-28'), ('220', '2016-11-11'), ('221', '2016-10-26'), ('222', '2016-11-12'), ('223', '2016-11-30'), ('224', '2016-10-28'), ('225', '2016-12-03'), ('226', '2016-11-18'), ('227', '2016-11-30'), ('228', '2016-10-31'), ('229', '2016-10-31'), ('230', '2016-12-01'), ('231', '2016-10-27'), ('232', '2016-11-11'), ('233', '2016-10-25'), ('234', '2016-12-05'), ('235', '2016-10-26'), ('236', '2016-10-27'), ('237', '2016-10-26'), ('238', '2016-10-27'), ('239', '2016-11-26'), ('240', '2016-10-26'), ('241', '2016-10-27'), ('242', '2016-10-27'), ('243', '2016-10-27'), ('244', '2016-11-29'), ('245', '2016-10-28'), ('246', '2016-11-26'), ('247', '2016-10-31'), ('248', '2016-11-28'), ('249', '2016-10-29'), ('250', '2016-10-28'), ('251', '2016-11-01'), ('252', '2016-10-27'), ('253', '2016-11-28'), ('254', '2016-12-05'), ('255', '2016-10-31'), ('256', '2016-10-31'), ('257', '2016-12-03'), ('258', '2016-11-01'), ('259', '2016-11-16'), ('260', '2016-12-02'), ('261', '2016-12-02'), ('262', '2016-12-01'), ('263', '2016-12-02'), ('264', '2016-12-02'), ('265', '2016-12-02'), ('266', '2016-10-28'), ('267', '2016-10-31'), ('268', '2016-11-05'), ('269', '2016-11-28'), ('270', '2016-12-07'), ('271', '2016-10-31'), ('272', '2016-11-14'), ('273', '2016-11-07'), ('274', '2016-11-07'), ('275', '2016-11-12'), ('276', '2016-10-31'), ('277', '2016-11-11'), ('278', '2016-11-05'), ('279', '2016-11-05'), ('280', '2016-12-05'), ('281', '2016-11-09'), ('282', '2016-11-04'), ('283', '2016-11-29'), ('284', '2016-11-08'), ('285', '2016-12-06'), ('286', '2016-11-30'), ('287', '2016-11-10'), ('288', '2016-11-08'), ('289', '2016-11-04'), ('290', '2016-12-03'), ('291', '2016-11-07'), ('292', '2016-11-05'), ('293', '2016-11-04'), ('294', '2016-11-07'), ('295', '2016-11-05'), ('296', '2016-11-15'), ('297', '2016-11-11'), ('298', '2016-11-10'), ('299', '2016-11-11'), ('300', '2016-11-08'), ('301', '2016-11-07'), ('302', '2016-11-22'), ('303', '2016-11-26'), ('304', '2016-11-07'), ('305', '2016-11-08'), ('306', '2016-12-05'), ('307', '2016-11-18'), ('308', '2016-11-09'), ('309', '2016-11-30'), ('310', '2016-11-29'), ('311', '2016-11-11'), ('312', '2016-11-09'), ('313', '2016-11-09'), ('314', '2016-11-09'), ('315', '2016-11-30'), ('316', '2016-11-10'), ('317', '2016-11-14'), ('318', '2016-11-11'), ('319', '2016-12-07'), ('320', '2016-12-07'), ('321', '2016-11-14'), ('322', '2016-12-07'), ('323', '2016-12-07'), ('324', '2016-12-07'), ('325', '2016-11-25'), ('326', '2016-12-02'), ('327', '2016-11-30'), ('328', '2016-11-11'), ('329', '2016-11-12'), ('330', '2016-11-17'), ('331', '2016-11-14'), ('332', '2016-11-11'), ('333', '2016-11-24'), ('334', '2016-11-18'), ('335', '2016-11-30'), ('336', '2016-12-08'), ('337', '2016-11-15'), ('338', '2016-11-30'), ('339', '2016-11-15'), ('340', '2016-11-22'), ('341', '2016-11-15'), ('342', '2016-11-22'), ('343', '2016-11-15'), ('344', '2016-11-14'), ('345', '2016-11-15'), ('346', '2016-12-07'), ('347', '2016-11-15'), ('348', '2016-11-15'), ('349', '2016-11-17'), ('350', '2016-11-24'), ('351', '2016-11-21'), ('352', '2016-11-26'), ('353', '2016-11-29'), ('354', '2016-12-03'), ('355', '2016-12-08'), ('356', '2016-11-19'), ('357', '2016-11-24'), ('358', '2016-12-05'), ('359', '2016-11-18'), ('360', '2016-11-30'), ('361', '2016-12-09'), ('362', '2016-11-25'), ('363', '2016-11-28'), ('364', '2016-11-21'), ('365', '2016-12-06'), ('366', '2016-11-22'), ('367', '2016-12-06'), ('368', '2016-11-24'), ('369', '2016-11-24'), ('370', '2016-11-29'), ('371', '2016-11-29'), ('372', '2016-11-29'), ('373', '2016-11-22'), ('374', '2016-11-22'), ('375', '2016-12-05'), ('376', '2016-11-25'), ('377', '2016-11-29'), ('378', '2016-11-22'), ('379', '2016-11-23'), ('380', '2016-12-07'), ('381', '2016-12-08'), ('382', '2016-11-30'), ('383', '2016-11-24'), ('384', '2016-11-29'), ('385', '2016-11-29'), ('386', '2016-12-08'), ('387', '2016-12-02'), ('388', '2016-11-25'), ('389', '2016-11-25'), ('390', '2016-11-29'), ('391', '2016-11-26'), ('392', '2016-11-30'), ('393', '2016-11-30'), ('394', '2016-12-08'), ('395', '2016-11-30'), ('396', '2016-11-29'), ('397', '2016-11-28'), ('398', '2016-12-01'), ('399', '2016-11-29'), ('400', '2016-11-28'), ('401', '2016-12-01'), ('402', '2016-11-29'), ('403', '2016-12-07'), ('404', '2016-12-06'), ('405', '2016-12-09'), ('406', '2016-11-30'), ('407', '2016-11-30'), ('408', '2016-11-30'), ('409', '2016-11-30'), ('410', '2016-11-30'), ('411', '2016-12-06'), ('412', '2016-11-30'), ('413', '2016-12-05'), ('414', '2016-12-06'), ('415', '2016-11-30'), ('416', '2016-11-30'), ('417', '2016-11-30'), ('418', '2016-12-07'), ('419', '2016-12-09'), ('420', '2016-12-08'), ('421', '2016-12-07'), ('422', '2016-12-08'), ('423', '2016-12-03'), ('424', '2016-12-07'), ('425', '2016-12-08'), ('426', '2016-12-08'), ('427', '2016-12-05'), ('428', '2016-12-03'), ('429', '2016-12-09'), ('430', '2016-12-05'), ('431', '2016-12-06'), ('432', '2016-12-09'), ('433', '2016-12-09'), ('434', '2016-12-07'), ('435', '2016-12-07'), ('436', '2016-12-09'), ('437', '2016-12-09');
19COMMIT;
20
21SET FOREIGN_KEY_CHECKS = 1;