CREATE TABLE `PP_G` (`date` date,`varchar_10` varchar(10),`date_key` date,`datetime` datetime,
`int_signed` int signed,`varchar_10_key` varchar(10),`varchar_5_key` varchar(5),`varchar_5` varchar(5),`int_signed_key` int signed,`datetime_key` datetime,        key (`date_key` ),
key (`varchar_10_key` ),key (`varchar_5_key` ),key (`int_signed_key` ),key (`datetime_key` )) ENGINE=innodb /*!50100 PARTITION BY range column_list(int_signed, varchar_10)                          subpartition by hash( to_seconds(`datetime`))                          subpartitions 3 (
                          partition p0 values less than (column_list(2, 'b')),                          partition p1 values less than (column_list(4, 'd')),                          partition p2 values less than (column_list(10,'za'))) */; 

INSERT IGNORE INTO PP_G VALUES  ('2006-03-10', 'r', '2002', '2006', '7', 's', 'v', 'f', '0', '03:35:53') ,  ('05:00:32', 'p', '2007', NULL, '5', 'd', NULL, NULL, '2', '20040715080745') ,  ('2002-08-21', 'z', '2006', '11:53:06', '4', 'x', 'n', NULL, NULL, '2001-05-22') ,  ('2009-10-23 22:20:02', 'j', NULL, '2007', NULL, 'b', NULL, 'b', '5', '2000-02-02') ,  ('17:17:28', 'c', NULL, '2004-02-27', '1', 'c', 'm', 'g', '1', '20060826073721') ,  ('2006', NULL, '23:11:14', '2001', '8', 'p', 'l', 'a', '7', '02:26:43') ,  ('2004', 'v', '2004-02-19', '10:46:03', '0', NULL, 'i', 'u', '
9', '02:39:32') ,  ('20070710223634', 'l', NULL, '12:17:26', NULL, NULL, 'w', 'u', '9', '2005-05-15') ,  ('2009-08-28 03:43:24', 'o', NULL, '2001-12-28',
 '3', 'g', 'a', 'l', '8', '2006') ,  ('01:13:44', 'r', NULL, NULL, '2', 'v', 'c', 'y', '3', '2001-04-22');

INSERT IGNORE INTO PP_G VALUES  (NULL, 'c', NULL, '09:38:34', '1', 's', 'f', 'l', NULL, NULL) ,  (NULL, NULL, '2000-10-27 04:34:00', '2007-06-14', '3', 'm', NULL, 'v', NULL, '2009') ,  ('13:14:03', 'q', '2000-06-07 22:17:43', '2000-07-04', '1', 'l', 'q', 'h', '8', '14:56:09') ,  ('2006', 'z', '2004-10-01 19:58:08', '2007-02-08 22:24:44', '1', 'e', 'm', 'v', '9', NULL) ,  ('2000-11-17 09:21:43', 'e', '2002-10-25 00:13:26', '2007-02-26 01:32:29', '3', 'f', NULL, 'd', NULL, '20070504151400') ,  ('2007-10-21 17:47:13', 't', '2000', NULL, NULL, 'a', NULL, 'k', NULL, '20010927075523') ,  ('2002-03-06', 's', '12:57:24', '2007-07-21 00:09:40', '4', 't', NULL, 'g', '2', '2005-02-08 07:40:59') ,  (NULL, NULL, '20071119035120', '2002', '9', 'j', 'h', 'a', '4', NULL) ,  ('19:31:45', 'k', '2006', '2004-01-19 03:04:25', NULL, 'l', 'x', 'z', NULL, '2008-07-11') ,  ('2004', NULL, '20040923002401', NULL, '0', 'p', 'p', 'i', '5', '2005-11-21');
 
INSERT IGNORE INTO PP_G VALUES  (NULL, 'n', '2002', '20020817042624', NULL, 'h', NULL, 'g', '5', '2008') ,  ('20050414050215', 'r', '2000-07-04', '00:20:42', '3', 't', 'x', 'z', '3', NULL) ,  ('2007', 'x', '2006-02-22 02:40:19', '2003-01-23 07:48:34', '5', 'n', 'v', 'y', '3', '2002') ,  ('2003', 'z', NULL, '17:00:36', '5', 'n', 'j', 'g', '9', '20070104194205') ,  ('14:00:04', 'e', '2006-10-06', '2007-11-09 05:17:13', NULL, NULL, 'm', NULL, NULL, '20001004181810') ,  ('2000', NULL, '2006', '20080215125401', '2', NULL, 'o', NULL, NULL, NULL) ,  ('20000612174428', NULL, '2001-03-19 20:24:09', '17:26:21', '1', 'p', 'g', NULL, '0', NULL) ,  (NULL, 'm', '20090113092003', '20080707072612', NULL, 'h', 'l', 'a', '9', '20010728192240') ,  ('13:29:06', 'x', '20020822104554', '2007-12-21', '1', 'y', 't', 'f', '8', NULL) ,  ('08:58:56', NULL, '2005-08-13 22:26:20', '2000-09-23', NULL, 'm', 'r', 'e', '1', '2003');

INSERT IGNORE INTO PP_G VALUES  ('2001-12-17', NULL, '2003-01-20', NULL, '9', 'n', 'e', 'k', '4', '20021217221247') ,  ('01:13:32', 'a', '02:29:47', '20031107131134', '3', 'n', 't', 'e', NULL, NULL) ,  (NULL, 'j', '20080426185633', '2008-04-09 16:23:45', '3', 'f', 'o', 'z', '5', '2004-01-08') ,  ('04:35:52', 'p', '2000-09-26 10:29:42', '2004-05-12', '0', 'w', 'g', 'm', '6', '2004') ,  ('2008-12-10 06:17:47', 'v', '2000-07-12', NULL, NULL, NULL, 'x', 'a', '6', '2008') ,  ('20:03:10', 't', '2001-04-04', '20001008181822', '9', 'c', 'y', NULL, NULL, '20060112032612') ,  ('00:03:41', 'o', '2006', '20020320211240', NULL, 'c', 'q', 't', '4', '2008-06-03') ,  (NULL, 'm', '20041106233606', '2004-06-24 03:06:30', '9', 'j', NULL, 'd', '2', '20011127164752') ,  ('20070414182526', 's', '04:56:59', '2002', '2', 'd', 'b', 'p', '0', NULL) ,  ('2007-06-09 09:45:10', 't', '2005-03-19 15:04:02', '2002-10-10', '4', 'k', NULL, 'q', '4', '2000-04-09 15:41:31');
 
INSERT IGNORE INTO PP_G VALUES  ('2007', 'n', '2008-10-03 18:45:37', '2003', '0', 'a', NULL, 's', '8', '2008') ,  ('2001-11-01', NULL, '2003', '14:23:35', '6', 'i', 'u', NULL, '9', '2005-09-07') ,  (NULL, 'i', '2008-05-04', '2007', '7', 'i', NULL, 'c', '4', '2001-04-07 05:11:31') ,  ('2001', 'y', '2002-06-26 15:49:50', '20050208134548', NULL, 'n', 'e', 'z', '7', '20040925040750') ,  ('2006-09-10', NULL, '20030312201308', NULL, '1', 'h', 'w', 'q', NULL, '2008-08-16 22:51:31') ,  (NULL, 'f', '2006-10-27 13:44:27', '2003-07-19 16:01:32', NULL, 'b', NULL, NULL, NULL, '2002-04-14 20:58:48') ,  ('2008-08-25', 'c', '04:40:14', '2001-06-27 23:30:50', '2', 'w', 'h', 'a', '7', '11:46:44') ,  (NULL, 'f', '2006', '14:58:03', '7', 'k', 'q', NULL, '7', NULL) ,  ('2009-05-14', 'p', '2008-11-21 19:03:09', '2007', NULL, 'q', 'w', 'c', NULL, '2000-06-23 09:11:58') ,  (NULL, NULL, '2009', '20010317014335', NULL, 'q', 'i', NULL, '4', '2006-02-16 00:54:16');
 
INSERT IGNORE INTO PP_G VALUES  ('20060127113011', 'm', '2007', '20010811074005', NULL, 'g', 'e', NULL, '3', '2007') ,  (NULL, 'l', '20051210154950', '23:54:20', '0', 'm', 'i', NULL, '9', '20080403094100') ,  (NULL, 'y', '02:55:20', '09:44:18', '7', NULL, 't', NULL, '4', NULL) ,  ('2001-06-26 23:51:26', 'g', '17:00:06', '20080713074420', '5', 'v', 'd', NULL, '8', '2004-12-09') ,  ('2002-10-13 12:38:09', 'p', '2005', '07:54:01', '1', 's', 'h', NULL, '5', '20020325051434') ,  ('07:19:37', 'g', '2004-03-16 06:19:55', '2009-09-01', '4', 'k', NULL, 'v', '1', '2002') ,  ('20000813020838', 'n', '09:46:44', '20070315172741', '3', 'c', 'q', 'r', '8', '20001204022159') ,  ('2006', NULL, NULL, NULL, NULL, 'g', 'v', 'd', NULL, '2009-07-19 06:37:29') ,  ('2007', 'd', NULL, '20061107005341', NULL, NULL, NULL, 't', '5', NULL) ,  ('20060424021512', 'k', '18:58:31', '20050920122112', NULL, 'j', 'y', 'b', '3', '2000-05-18');

INSERT IGNORE INTO PP_G VALUES  ('2002', NULL, '10:30:54', '03:36:50', '5', 'y', 'e', 'j', '8', NULL) ,  ('2004-09-09 23:01:25', 'j', '20070423114355', '16:07:23', '1', 'i', 'y', 'e', '9', NULL) ,  (NULL, 'g', '2009', '2007-11-23 07:42:02', '2', NULL, NULL, 'q', '0', '2000') ,  ('20020128001641', 'm', '2006-02-25 07:44:57', '21:31:57', '0', 'w', NULL, 'w', '1', '2006-11-07 19:23:09') ,  ('2002-11-06', 'o', '2002-03-10', '01:56:10', '2', 't', 'f', 'm', NULL, '2006') ,  ('02:19:46', NULL, '20090305151656', '2009', '2', 'z', 'o', NULL, '1', '20070224121352') ,  ('2006-12-10', NULL, '07:45:54', '20021107144215', '6', 'k', 'l', 'x', '7', '2004-10-08') ,  ('2001', 'b', '2000-09-13 22:36:24', '21:21:08', '2', 'y', NULL, 'k', '2', '2008') ,  ('20001228072302', 'j', NULL, '20000516042728', '2', 'm', 'z', 'c', '2', '2001') ,  ('2008', 'k', '2002-09-12', '08:26:26', NULL, 'g', 'e', 'u', NULL, '20011114065420');
 
INSERT IGNORE INTO PP_G VALUES  ('2004-11-10', 'k', '20040921145359', '2005-03-02', '8', 'v', 't', 's', '7', '2008-05-11') ,  ('18:25:30', 'q', '14:02:39', NULL, '9', 'l', 'z', NULL, '4', '2007') ,  ('20061209125526', 'd', '2001-06-06', '22:45:58', '8', 'j', NULL, 'h', '1', '20070904231231') ,  ('21:09:15', 'u', '20080627091456', '08:04:12', '4', 'p', 'x', NULL, '7', '2008-08-16 00:29:57') ,  ('20020102183627', 'e', '20020625101519', '2007-05-05 00:21:26', NULL, 'w', 'o', 'w', '9', '08:07:04') ,  ('2001-05-06', 'r', NULL, '12:36:29', '1', NULL, 'j', 'o', '1', '2007-01-19') ,  ('2009', NULL, '2000-11-05', '2004-06-26', NULL, 'w', 'i', 'f', '0', '2000-11-04') ,  ('2002-01-07 17:58:11', 'l', '2002-05-02 09:18:16', NULL, '3', 'f', 'o', 'p', '7', '20050512190333') ,  ('20010604014459', NULL, '20000614024453', '2008-08-27 11:30:23', '2', 'l', 't', 'i', NULL, '2003-12-09') ,  (NULL, 'x', '2005-05-22 00:38:57', NULL, '3', 'n', 'h', 't', NULL, '2007');

 INSERT IGNORE INTO PP_G VALUES  ('20010804173759', NULL, '2002', '20031107064633', '3', 'q', 'f', NULL, '2', '21:02:57') ,  ('2005-12-10', 'j', '2007-05-10', NULL, NULL, NULL, 'i', 'u', '0', '10:19:20') ,  ('2009-07-11', 'c', '2008', NULL, NULL, 'w', NULL, 'p', '4', '2007-05-19') ,  ('20030402131356', 'f', '09:50:39', '20001002194301', '4', 'e', NULL, 'c', '0', NULL) ,  ('21:13:24', 't', '20060502033232', '2008-03-13 19:07:18', '2', 'd', 'y', 'z', '1', '20050115063216') ,  ('2008', 'h', '11:00:38', NULL, '8', 'n', 'c', 'e', '4', NULL) ,  ('07:58:15', 'v', NULL, '2000-05-08', NULL, NULL, 'u', 'j', '3', NULL) ,  ('2006', 'g', '15:15:11', '00:17:32', '8', 'p', 's', 'i', '2', NULL) ,  ('2008-06-10', NULL, '2008-06-10', '2006-10-12', '3', 'h', 'x', NULL, '8', '2006-07-23') ,  ('20080116162540', 'n', '20000606223720', '20060204205611', '5', 'g', 'p', 'c', '7', '2007');

 INSERT IGNORE INTO PP_G VALUES  ('20081106053739', 'w', '05:41:01', '2007', '1', 'f', NULL, 'c', '2', '2004-11-08') ,  ('2006-07-14 07:46:52', 'h', '2004-05-14 14:38:05', '20091220183104', NULL, 't', 'e', 'm', '9', '2002-08-07 06:47:28') ,  (NULL, 'w', '2004-09-28', NULL, '3', 's', 'e', 'j', '0', NULL) ,  ('2003', 'l', '20040216122651', '05:20:46', '3', 'm', 'i', 'i', '4', '2003') ,  ('20070921152540', 'g', '2008-10-19', '2007', NULL, 'z', 'w', 't', '0', '20080601055521') ,  ('20020106190609', 'e', '20010122083753', '2002-11-06', '0', 'n', 'h', 'l', NULL, NULL) ,  ('2007-04-11 02:13:10', 'd', '2001-05-10', '20090707135216', '2', NULL, 'l', 'm', '9', '20010913114031') ,  ('10:47:29', NULL, '2006', '14:01:13', '8', 'x', NULL, 'z', '5', '2002') ,  (NULL, 'g', '2008', '2005', '9', 'v', 'z', 'x', '1', NULL) ,  ('2008', NULL, NULL, '2000', '7', NULL, 'r', 'x', '7', '2000-05-07 01:17:03');

UPDATE `PP_G` SET `varchar_5` = 'c' WHERE ( `PP_G` . `varchar_5` > 'f' );

DROP TABLE `PP_G`;