CREATE TABLE `PP_H` ( `varchar_10_key` varchar(10), `varchar_5` varchar(5), `datetime_key` datetime, `int_signed` int signed, `varchar_5_key` varchar(5), `date` date, `varchar_10` varchar(10), `datetime` datetime, `int_signed_key` int signed, `date_key` date, key (`varchar_10_key` ), key (`datetime_key` ), key (`varchar_5_key` ), key (`int_signed_key` ), key (`date_key` )) ENGINE=innodb /*!50100 PARTITION BY range column_list(varchar_5, varchar_10) subpartition by hash ( year(`date`)) subpartitions 2 ( partition p0 values less than (column_list('m','m')), partition p1 values less than (column_list('zz','zz'))) */; --disable_warnings --disable_query_log INSERT IGNORE INTO PP_H VALUES ('s', 'n', '21:36:11', '8', 'd', '2003-06-10 10:35:13', 'j', '20050625030043', '8', '2007-02-24') , ('l', 'e', '2004-11-15', '4', 'j', NULL, 'x', '2003-11-20', '4', '20051109194117') , ('o', 'j', '03:30:22', '5', 'g', '2003-04-17 21:07:39', 'f', '2001-06-25', '6', '2008-06-25') , (NULL, 'd', NULL, NULL, 'l', '20071115024241', 'd', '20030403210726', '5', NULL) , ('j', 's', '2001', '1', 'm', '20030205150319', NULL, '20050514153819', '1', '20040928191028') , ('v', 't', '2006', '2', 'h', '2009', 'e', NULL, '4', '2006') , ('r', 'n', '14:47:41', NULL, 'q', '2003-02-23', NULL, '22:57:59', '3', NULL) , ('a', 's', '00:51:37', '4', NULL, '2002', NULL, '20021002021431', '3', '2007-05-28') , ('c', NULL, NULL, '5', 'a', '19:20:49', 'x', '20060304011004', '2', '2003') , ('n', NULL, '20080427051450', '3', 'b', '2003-09-20', 't', '2003-07-14', NULL, NULL); INSERT IGNORE INTO PP_H VALUES ('c', 'o', '2004', '0', 'g', '2004-04-05', 'o', '2006-12-10 19:38:17', '0', NULL) , ('t', NULL, '2009', NULL, 'b', '03:45:05', 'a', NULL, NULL, NULL) , (NULL, 'c', '20070713113518', '4', NULL, NULL, 'j', '19:54:35', '5', '20060125152517') , ('u', 'e', '2004-12-20', NULL, 'o', '2000', 'x', '10:05:47', NULL, '2006') , ('a', NULL, NULL, '6', 'f', '2006', 'z', '2006-01-22', '7', NULL) , ('o', 'k', '2001-01-08', '3', 'q', '2004-01-17 13:42:53', 'f', '22:14:53', NULL, '2002') , ('s', 'w', '2009-03-05', NULL, NULL, '2009', 'e', '2003', '8', '2001') , ('w', NULL, '2006-06-08', '1', 'k', '2008-08-04', 'd', '2001-03-24 06:35:40', NULL, '12:20:10') , ('n', 'u', '2006', '5', 'c', NULL, NULL, '2002', '8', NULL) , ('o', NULL, '2006', NULL, 'v', NULL, 'j', '20011208180925', '3', '20080603203957'); INSERT IGNORE INTO PP_H VALUES ('v', 'f', '2009-02-10 08:04:40', '0', 't', '2008-12-05', 'u', '2000-01-09 13:52:04', '1', '20020319000104') , ('y', 'w', '2004-10-22', '1', NULL, '2009-03-23 22:39:38', 'e', '2009', '5', '2004-11-21 10:37:35') , (NULL, 'v', '20011014230233', NULL, 'c', '2007-05-24', 'x', '2002', '7', '03:45:00') , (NULL, 'y', '2003', '8', NULL, '01:03:01', 'w', '2003-09-25', '3', '13:42:32') , (NULL, 'q', '2000-09-23', '6', 'j', '2000-10-08', 't', '2007-11-02 19:36:29', '3', '2009') , (NULL, NULL, '2006-01-05 07:22:20', '1', 'l', '2005', NULL, '2000', '0', NULL) , ('i', 'b', NULL, '5', 'r', '2001-02-24 22:56:39', NULL, '2006-02-13', '3', '2000-06-27 14:56:35') , ('v', 'p', '2007-09-22', '4', 'v', '04:32:22', 'l', NULL, NULL, '2002-08-16') , ('o', 'q', NULL, '7', 'm', '2000', NULL, '21:54:38', '5', NULL) , ('p', 'z', NULL, '7', 'i', '20081227142620', 'a', '2009-09-01', '5', '2006-11-18'); INSERT IGNORE INTO PP_H VALUES ('t', 'u', '2003-05-25', '2', 'w', '20071025215032', 'c', '2000', '4', '20081120121556') , ('j', 'h', '2007-10-04', '6', 'l', '2007', 'm', '17:17:59', '9', '21:35:04') , ('w', 'b', '20020419115204', '6', 'b', NULL, 'w', '2004-09-06', '6', '20090321203808') , (NULL, 'z', '2007-03-11 05:37:56', '5', NULL, '2002-11-12', NULL, '2006', '2', NULL) , ('d', NULL, '2002', '4', 'o', '2008', 'd', '2002-09-09', '2', '2000') , ('x', 'f', '2005-11-21', '4', NULL, '2008', 'v', '2008', '4', '18:33:40') , ('w', NULL, NULL, '5', 'y', '2000-08-09', 'v', '2008-04-07', NULL, NULL) , ('u', 'b', '2004-07-02', '1', 'v', '20080704235759', 'r', '2002', '7', '02:09:51') , ('c', 'j', NULL, '6', NULL, '2001-10-17 16:54:54', 'q', NULL, NULL, NULL) , (NULL, 'j', '2008-10-14', '2', 'h', '2006-01-13 01:25:15', 'h', '20061107071241', '8', '2007'); INSERT IGNORE INTO PP_H VALUES ('e', 'q', '2007-01-27', '2', 'e', NULL, 'k', '20080921103446', '7', '20060220132513') , ('g', 'n', '06:27:44', '0', 'e', '20081025055942', 's', '20050427112411', '8', NULL) , (NULL, 'n', '2000-11-09 10:32:23', '6', 'y', '10:55:51', NULL, '2008-09-09 11:16:01', '7', '2008') , ('u', 'p', NULL, NULL, 'q', NULL, 'g', '2003', '4', '2004-09-15 01:03:34') , ('u', 'w', '20040222161538', '7', NULL, '2004-06-18', 'i', '00:40:19', NULL, '2009-09-06') , (NULL, 'o', '2009', '3', 'j', '2006-03-18 02:39:37', 'f', '2001-04-02', '6', '2000-12-17') , ('l', 'l', '01:25:54', '3', NULL, '2009', 'a', '2004-11-07 23:29:25', '9', '20081117083939') , (NULL, 'q', '2007-12-27 19:42:04', '1', 'c', '2002-10-26', 'y', '01:40:03', '8', '10:58:36') , ('v', 'q', '20081026122800', '2', 'u', '20051107160713', 'j', NULL, '7', '2008') , (NULL, 'u', '2003-02-03', '2', NULL, '2006-07-05 09:38:23', 'x', '08:13:09', '4', NULL); INSERT IGNORE INTO PP_H VALUES ('n', 's', '20030908090854', '5', NULL, '2001', 'q', '19:52:31', '0', NULL) , ('t', 'p', '2008-11-06', '7', 's', '2005', NULL, NULL, '4', '2006') , ('h', 'h', '2008', '4', NULL, '2005', 'k', '2007', '3', '18:48:32') , (NULL, 'u', '20021007134156', NULL, NULL, '20031123172703', 'a', '2004', '8', '2004-07-04 10:08:08') , (NULL, 'a', '02:01:38', NULL, NULL, '2008-07-06', 'x', '2006-06-23', '8', '01:56:05') , ('d', 'l', '2005', '2', 'd', '2007', 'l', '2008-07-11', NULL, '2002-01-26 06:01:41') , ('u', 'y', '19:18:50', NULL, 'a', NULL, NULL, '2009-03-27 10:30:36', '3', '2009-06-26 11:05:58') , (NULL, 'e', '2008-09-01 21:32:00', NULL, 'l', '14:01:11', 'n', '05:15:59', '4', '2001') , ('s', 'u', '20050219113237', '4', 'w', '20030804064715', 'l', '17:20:14', '1', '2004') , ('j', NULL, '2006-05-25', '2', 'm', '2009', 'q', '2005-04-26 22:56:19', '7', '2006-07-03'); INSERT IGNORE INTO PP_H VALUES ('k', 'c', '2002-04-20', NULL, 'l', NULL, 'h', '2001-10-11 11:01:24', '9', '20090122190104') , ('t', 'a', '2006-05-01 12:07:23', '2', 'i', '2006-10-12 03:10:11', 'd', '20080209061711', '8', '01:45:24') , ('p', 'j', '2008', '8', 'l', '2001-04-05', 'l', '2004-02-02', '0', '10:02:27') , ('b', 'j', '2001', '5', 'q', '13:00:13', 'j', '2002', '4', '2007') , ('l', 'j', NULL, NULL, 'm', '20060625043041', 'r', '11:16:23', '0', '2001-10-03') , ('p', 'f', '2001-10-02 01:14:41', '2', 's', '2006', 'd', NULL, '1', '20070711215934') , ('m', 'v', '2009-04-27 20:29:16', '7', NULL, '2007-07-15 23:39:06', 'x', '20000405083957', '9', '2002') , ('h', 'f', '2005', NULL, 'h', '2006-12-23 08:59:27', NULL, '2002-07-04 00:50:51', '7', '2007-11-25 01:22:52') , (NULL, 'p', '07:12:37', '3', NULL, NULL, 'p', '20080509192745', NULL, '2000') , (NULL, 'k', '2009', '0', NULL, NULL, NULL, '20080827225328', '4', '20:13:17'); INSERT IGNORE INTO PP_H VALUES ('e', 'r', '2003-04-03 07:35:26', '8', 'y', '2008-04-19 20:21:54', 'b', NULL, '6', NULL) , (NULL, 'j', '2001-10-24', '1', NULL, '23:27:31', 'w', '15:41:16', '4', '22:29:30') , (NULL, 'f', '2004-10-17 06:44:34', '7', 'a', '2003-09-15 00:00:39', 'p', '20010716024148', '5', '20060306230442') , ('n', 'f', '2009-06-04 11:46:24', '3', NULL, '2006-06-16 18:47:46', 'r', NULL, NULL, '19:31:09') , ('c', 't', '2001-08-06 21:57:02', '3', NULL, '2004', NULL, '2009-04-16', '1', '20061218074148') , ('i', NULL, '23:58:14', '4', 'm', NULL, NULL, NULL, '3', '15:50:23') , ('s', 'q', NULL, '9', 'p', '20030803183706', 'i', '2007-11-01 16:10:53', '7', '2000-04-09 04:37:12') , ('f', NULL, '2009', '9', 'b', '08:44:01', 'w', NULL, '8', '09:15:21') , (NULL, 'z', '2002-07-27 16:53:46', NULL, 'w', '2009', 'a', '2008-07-24', '1', '20030611235859') , ('a', 'v', '2008-11-27', '0', 'e', '2001', 'm', '2008', NULL, '2003-07-12'); INSERT IGNORE INTO PP_H VALUES ('q', 't', '2003', '2', 'c', '2004-12-10 02:53:05', 'd', '18:58:01', '4', '2002-07-18 23:57:57') , ('w', 'y', '2007', '4', NULL, '2008-04-09 12:36:13', 'x', '2006-09-22 17:31:55', '6', '2007') , ('h', 'x', '2008', '0', 'w', '2006', 'g', NULL, '9', '2001') , ('p', 'p', '2008-10-27 22:36:52', '5', 'e', NULL, NULL, '02:53:28', '9', '12:15:01') , ('u', 'l', '2009-12-19', '9', 'd', NULL, NULL, '2001-12-04 04:07:15', '9', '2006-10-27') , ('h', 'v', '2005-01-07', '3', 'o', '2004-10-24', 'i', '2002-08-21 13:29:30', '4', '2001-08-04') , (NULL, 'e', '20030928082646', '3', 'b', '2006-05-21', 'q', '2007-09-24', '5', '20030817170406') , (NULL, 'x', '2006-08-13 09:47:12', NULL, 'l', '2005-07-24 15:33:09', 'v', '2002-08-02 19:47:31', '3', '20030312012402') , ('m', 'b', '20070906004741', NULL, 's', '2006-11-15 22:40:51', 'g', '2004-01-14', '8', '2003') , ('v', 'n', '2001', '6', 'x', '02:13:56', 't', '2009-06-09', NULL, '2007-07-21'); INSERT IGNORE INTO PP_H VALUES ('p', 'm', NULL, '4', NULL, '2007-07-24 22:20:32', 'a', '13:55:08', '9', '21:13:05') , ('c', 'x', '20080125002216', '9', 'f', '20030828001119', 'u', '02:36:24', NULL, '2005-09-19 00:44:49') , (NULL, 'j', '2004', '9', 'j', '2009-10-23', 'y', '2000-12-24', '3', '20030311235807') , ('i', 'y', '2005', '8', NULL, '2008-12-28 03:34:39', 'b', '2005', '2', '20070424223305') , ('u', 'u', '2001-12-20', '3', NULL, '2009-04-12 14:30:33', 'y', '2007-08-17', '2', '2009-08-21') , ('c', 'z', '2001-02-22', '8', 'w', '20020310073337', NULL, '2004-03-02 06:55:28', '2', '2005-10-27') , ('n', 'x', '20030114174203', '5', 'p', '2005-09-08', 'e', '2002', '3', '20071220044047') , ('y', NULL, '01:46:34', '5', NULL, '2002-06-14', 'c', '2004-02-21', '3', '23:42:40') , ('e', 'x', '2004-06-03', '8', NULL, '06:46:52', 'z', NULL, '7', '2001-06-17') , (NULL, 'c', '00:24:43', '3', NULL, '20070626210626', 'n', '2003', NULL, '2009'); INSERT IGNORE INTO PP_H VALUES ('z', 'p', '2006', '1', 'b', '20010724044808', 'i', '2009-02-06 03:00:29', '6', '23:45:17') , ('m', NULL, NULL, '5', NULL, '11:21:05', 'a', '20081206195521', '8', '2009-10-19 08:31:46') , ('m', 't', NULL, '7', 'w', NULL, 'o', '2009-02-12 10:51:35', '2', '2005-09-21') , ('l', 'd', '15:22:28', NULL, 's', '20031028095305', NULL, '20031215030538', '6', '2004') , ('t', 'q', '2008-05-03', '7', 'v', '2005', NULL, '2004-01-24', '9', '13:10:53') , ('p', 'm', NULL, NULL, 'm', '2004-11-02', 'm', '20051208141918', '2', NULL) , ('p', 'u', '2005-09-18 08:04:12', '7', 'r', '2007', 'w', '2009', '3', '01:06:13') , ('n', 'f', '20010914215955', '3', 'x', '17:31:43', 'd', '20020625050433', NULL, NULL) , ('k', 'd', NULL, '4', NULL, '2005', 'q', NULL, '5', '2003-11-10') , ('q', 'z', '20010920002015', NULL, NULL, '20010827113526', 'o', '2005-09-13', '0', '2002'); INSERT IGNORE INTO PP_H VALUES ('z', 'v', '20030701074429', '7', 'q', '2002', NULL, '2000-11-10 05:01:01', NULL, '2000') , ('h', 'j', '11:48:33', NULL, 'q', '20080107092114', NULL, '08:48:17', '5', '20090803031301') , (NULL, 'd', '2002', '7', 'd', '2005', 'j', '20070222174011', '8', '2001-03-24 11:24:51') , ('a', 'm', '2007-12-01 08:52:29', '6', 'h', '2008-12-15 11:13:26', 'z', NULL, '3', NULL) , ('f', 'e', NULL, '1', NULL, NULL, 'k', '2005-12-08', NULL, '2003-10-28') , ('m', 'k', '2004-10-28', '6', 'v', NULL, 'e', '2009-03-07 11:31:30', '2', '22:59:02') , ('w', NULL, '02:36:50', NULL, 'w', '2001', 'y', '20090825151738', NULL, '2009-11-01 15:46:02') , (NULL, 'd', '11:11:24', '3', NULL, NULL, 'b', '20090524095208', '0', NULL) , ('w', 'c', '2000-11-09', '4', 'm', '20080323042927', NULL, '2005', '9', '20010501053552') , ('z', 'w', '2009-01-14', '8', NULL, '20080223154812', NULL, NULL, '1', '20071108180514'); INSERT IGNORE INTO PP_H VALUES ('n', 'h', '01:27:48', '4', 'v', '06:27:42', NULL, '2003', '9', '01:48:46') , (NULL, NULL, '20011123224017', NULL, NULL, NULL, 'a', '20060101215907', NULL, '2001') , ('l', 'e', '20000417203121', '0', 'b', NULL, NULL, '2007', '8', '2007-04-04 04:22:16') , ('t', 's', '20050716095311', NULL, 'h', '2000-11-23', NULL, '18:58:37', NULL, '2001-04-09 11:40:03') , ('k', NULL, NULL, '0', 'q', '17:27:10', 'w', '23:44:14', NULL, '20080522162738') , ('g', 'a', '2006', '0', NULL, '06:38:27', NULL, '2008', NULL, '2009-12-13 20:50:09') , ('w', NULL, '2001', '6', 'i', '2006-06-11 09:23:33', NULL, '05:09:57', '1', '20090920234417') , ('q', 'x', '20090224043447', '6', 'i', '2001-05-27 07:49:34', 'o', '2007-02-10', '0', '20061122064052') , ('i', NULL, '2002-05-17 05:51:09', '9', 'z', '18:07:23', 's', '2009-04-09 18:19:47', '2', '21:40:13') , ('k', 'r', '20030513025107', '7', 'i', '15:18:49', 'y', NULL, '5', '07:51:19'); INSERT IGNORE INTO PP_H VALUES ('k', 'y', '2003-08-24 14:40:24', NULL, NULL, '20000911191948', 'v', '2002', '2', '09:55:32') , (NULL, 'i', '2009', '3', 'y', '2003-03-08', NULL, '20000820012341', '3', '2006-03-05') , (NULL, 't', '2008-07-18', '3', 'x', '2000-05-08 09:03:40', NULL, '00:29:25', '4', '2004') , ('a', 'v', '2005', '0', 'm', '20010901221606', 'q', '2009-10-17', '3', '2005-03-08') , ('v', 'z', '08:51:07', '3', 'n', '2006-12-20', 'r', '20030815030222', '0', '2002-09-26 22:45:40') , ('e', 'j', '2007-03-15', '2', NULL, NULL, 'g', '2000', '2', '20070921083152') , (NULL, NULL, '2008-07-01 23:51:58', '5', 'q', '2006', 'h', '2009-01-28 01:15:53', NULL, '20001225200914') , ('k', NULL, '2002', '0', 'i', '2005-04-04 10:22:29', 'h', '20030718185331', '7', '13:54:15') , ('s', 'v', '2009-09-19 12:49:50', NULL, 'w', NULL, 'e', '2001-07-13', NULL, '20041223044306') , ('e', NULL, '2007-04-14 05:15:33', '8', 'e', '17:04:26', 'r', NULL, '8', '2000'); INSERT IGNORE INTO PP_H VALUES ('a', NULL, '2000-10-15 04:24:00', '3', NULL, '2005', NULL, '20001026104848', '9', '2006-04-10 15:24:09') , ('h', 'e', NULL, '4', 'l', '17:37:21', 'u', '2008-08-06', '7', '20041106134547') , ('n', 'n', '12:00:03', NULL, 'y', '2007-12-16', 'j', NULL, '3', '2000') , (NULL, 'z', '2005-09-05 19:14:14', '9', NULL, '2001-03-02 19:27:58', 'm', '2009-12-08 15:01:30', '1', '2003-04-21') , ('b', 'w', '00:08:22', '4', NULL, '2003-12-07', 'u', '2009-06-08 08:27:46', '8', '2001-09-06 03:36:10') , ('b', 'u', NULL, '3', 'b', '05:18:34', 'l', '2000-05-05', '1', '2003-04-01') , ('l', NULL, '20050428074842', '7', NULL, '2004-10-19 20:00:49', 'a', '01:37:21', '7', '2004') , (NULL, NULL, '2005', NULL, 'v', '2009-05-08', 'm', '2003-07-23', NULL, '2009') , ('q', 'p', '2009', '4', 'u', '02:58:18', 'h', '2001-10-26 13:55:15', '4', '15:53:46') , ('j', 'e', '07:52:29', '3', 'b', '20050116153749', 'b', '2009-02-18 21:25:50', '0', NULL); INSERT IGNORE INTO PP_H VALUES ('o', 's', '20030406160953', '1', NULL, '2005-08-11', NULL, '2009-02-03 14:36:42', '3', '20030226130525') , ('i', 'l', '2004', '1', 's', '22:49:21', 't', '2004-02-18 09:57:06', NULL, '20070408152153') , ('h', 'o', '18:55:05', '0', 'w', '2003-07-04', 't', '2005-09-08', '7', '20040518164134') , (NULL, 'b', '09:41:14', '4', 'q', '2001-02-01', 'n', '2000-02-12 15:17:42', '7', '2006') , ('p', NULL, '2006-03-22 00:19:27', NULL, 'r', '2000-09-21 23:50:10', 'n', NULL, '5', '23:27:52') , ('q', 'n', '20:09:31', '9', 'w', '03:22:17', 'q', '20090621054147', '8', '20020702231215') , ('b', NULL, '2005-12-05 23:12:17', NULL, NULL, '2004-05-03 16:35:06', NULL, '2002', NULL, '2002') , ('m', 'q', '2007-10-18', '3', NULL, '20010822220910', 'c', '2000-07-14 10:50:14', '0', NULL) , ('d', 'u', '2002', '0', 's', NULL, 't', '2001-01-22 17:31:49', '2', '2000-09-23 06:38:04') , (NULL, 'i', '2002-11-18 23:40:59', '1', 'w', '2006', 'd', '2006-05-02 04:06:47', '0', '2006'); INSERT IGNORE INTO PP_H VALUES (NULL, 'r', NULL, '2', 'z', '12:28:56', NULL, '2007', '7', '2007-09-23 05:10:55') , ('k', 'r', '2004-09-15', '0', 'f', '2000-12-16', 'i', '2004-01-27 23:11:09', NULL, '2005-02-14') , ('v', 'k', '2004-11-25', '1', NULL, '2006-01-20', 'r', '12:43:51', NULL, '20040821182832') , ('i', 'e', '2006', '4', 'q', '2001', 'j', '2005', '0', '2003-04-22') , ('w', 's', '2009-02-09', '3', 'd', NULL, 'e', '2009-04-24 09:23:24', '9', '2008-08-16 00:45:52') , ('u', NULL, '2003-01-10', '0', 'z', '2006', 'y', '2008', '2', '2005-07-25 18:12:24') , ('k', NULL, '2003-02-03 15:34:20', '5', 'k', '2009-03-28', NULL, '2009-07-16 04:49:39', NULL, NULL) , ('q', NULL, '2000-08-07', NULL, 'm', '2000-12-12', 'm', NULL, NULL, '04:14:27') , ('b', 'o', '2001-12-10', NULL, 'g', '20050410170009', 'y', NULL, '0', NULL) , ('b', NULL, '2008-02-27 14:49:50', '6', 'x', '20010714145157', 'j', '2005', '6', '2002-11-17 18:21:42'); INSERT IGNORE INTO PP_H VALUES ('h', NULL, NULL, '7', 'u', '20061211084731', NULL, '12:02:59', '8', '2007-02-14 03:23:17') , ('k', 'l', '2003-09-11 07:29:00', '3', 'n', '2000', 'l', '2007', '6', '2000-04-15 00:32:22') , ('p', NULL, '2007-01-27', '9', 'j', NULL, 'g', '2003-12-14', '9', '05:35:22') , ('q', 'c', NULL, NULL, 'a', NULL, 'o', '05:49:50', NULL, '05:09:56') , ('u', 'y', '2007-05-26', '1', 'z', '2002-02-26', 'i', '19:10:25', '2', '00:46:48') , ('r', 'r', NULL, NULL, 'd', NULL, 's', '20031213011511', '2', NULL) , (NULL, 'v', '2001', '2', NULL, '23:26:27', NULL, NULL, '8', '2004-11-28 15:54:58') , (NULL, NULL, '2000-02-12', '0', 'w', '20001102235829', NULL, '20001221212154', NULL, '2003-06-06') , ('k', 'a', '20021219201540', '6', 'o', '20050906164550', 'd', '2004', '1', '05:58:10') , ('c', 'x', NULL, '0', 't', '2000-04-15 16:52:32', 'v', '2006-12-21', NULL, '2009-10-21'); INSERT IGNORE INTO PP_H VALUES ('l', 'g', '2005-11-14 01:37:42', '6', 'l', '2005-12-26 00:03:42', NULL, NULL, '1', '2002-06-27 09:38:42') , ('o', 'l', NULL, '4', NULL, '20030228003106', 'v', NULL, '1', '2003') , ('t', 'r', '20030425142729', NULL, NULL, '2009-01-10 17:54:00', 'v', '2009-07-18', '1', '2000-03-18') , (NULL, 'l', '2005-03-07 22:40:10', '2', NULL, '21:29:49', 'w', NULL, NULL, '20010317152659') , (NULL, 'y', '20000403090357', '7', 'v', '2006-02-01', 'r', '01:01:42', '6', '20080528134738') , ('k', 'm', '2004-12-12 15:28:10', '7', 'a', '2007-10-17 02:21:59', 'f', NULL, '6', '2008-02-10 03:31:44') , (NULL, 'i', '2007-07-18 06:29:36', '1', NULL, '2004-10-06 10:08:33', 'i', '07:33:35', NULL, '12:35:41') , ('o', 'y', '2009', '7', NULL, '2001-05-06', 'i', '2007', '2', '00:09:32') , ('l', 'i', '2005', '7', NULL, '2002-04-14 07:57:43', 's', '2009-06-15', '8', '15:57:35') , ('d', 'm', NULL, '6', 't', '2004-07-19 03:39:41', 'd', '20040409092531', NULL, '2008-04-07 20:03:15'); INSERT IGNORE INTO PP_H VALUES ('r', 'f', '20021023072524', '1', 'k', '2002', 'j', NULL, NULL, '2006') , (NULL, 'z', '2008-04-06', '5', 'l', NULL, 'l', '20070625152627', '2', '2008-09-12') , ('b', 'c', '2009-06-07', '4', 'd', '2001-11-22', 's', '20:06:46', '0', '2007') , ('j', 'v', '2001-01-25 19:04:22', NULL, 'o', NULL, 'e', '2007-08-04 03:24:13', '1', NULL) , ('y', NULL, NULL, '9', 'y', '2001-12-16 21:54:34', 'd', '2004', '6', '02:07:55') , (NULL, 'o', '15:37:00', NULL, 'b', NULL, 'z', NULL, '3', '2005-10-16') , ('s', 'g', '20050916032238', '7', 'i', '2002-05-23', NULL, '2006', '4', '2007-05-24') , ('d', 's', '20000405155711', '0', 'h', '2002-08-25 01:39:18', 'm', '2001-02-25 23:08:12', '9', '2006-02-15 07:26:35') , (NULL, 'z', '2000-01-10', '2', 'c', '20080401074814', NULL, '2005', '0', '2006-07-17 18:03:34') , ('z', 'a', NULL, '3', 'q', '20090805234030', 'j', '2007-01-23 06:10:47', '2', NULL); INSERT IGNORE INTO PP_H VALUES ('l', 'i', '2004', NULL, NULL, '2009-06-07', 'b', '20060724043312', '4', '2009-08-18') , (NULL, 'q', '2003', '7', 'a', '2001-12-11 13:44:32', 'r', '2009-11-27 20:27:46', '5', '2006') , (NULL, 'p', '2007', '6', NULL, '20:27:45', 'h', '2005-01-20 13:03:15', '0', '2002-09-17') , ('b', 'c', '04:41:59', '5', 'k', '2001-09-14 15:15:32', 'y', '2008', '0', '2008-05-19') , (NULL, 'v', '2000', '6', 'h', '2001-03-18 17:06:16', 'e', '2001', '5', '12:18:45') , ('p', 'm', '20010222132712', '5', 'c', NULL, 'v', '2001-02-02', '4', '2008-05-28') , ('n', 'z', '02:14:51', '8', NULL, '2009', NULL, '2005-05-04 19:23:57', NULL, '2008-05-01') , ('m', 'v', '2000-12-20', NULL, 'y', NULL, NULL, NULL, '3', NULL) , ('x', 'l', NULL, NULL, NULL, '2002-08-09 16:20:03', 'k', '20050726143810', '2', '2004-11-14') , ('p', 'l', '2006-10-17 01:44:08', '3', NULL, NULL, NULL, '20010413190626', '1', '2002-07-17 15:37:38'); INSERT IGNORE INTO PP_H VALUES ('r', 'u', '11:19:53', NULL, 'e', '20091213085436', 'i', '2009', '6', '02:13:32') , ('v', 'f', '2006', '4', 's', '2006-05-14 03:24:54', 'a', '2007', '4', '2008') , ('e', 't', '2004-07-02', '7', 'q', '2001-12-14 03:58:53', NULL, '2004', '7', '20031208165927') , ('h', 'y', '2002', '6', 'c', '05:13:10', NULL, '23:05:12', '7', '2008-09-07 00:20:46') , ('l', 'o', NULL, '8', 'a', '20:06:48', 'k', NULL, '3', '2008') , ('c', 'c', '2000-02-09', '4', 'j', '2008-08-18 21:49:16', 'l', '2001', '7', '2001-07-01 22:31:01') , (NULL, 'u', '20070322151211', '1', NULL, '2006', 'p', '2009-01-25', '9', NULL) , ('q', NULL, NULL, '4', 'i', '20060304134813', 'p', NULL, '3', '20050924191848') , ('y', 'j', '20061112073218', '5', 'u', '01:11:02', 'c', '17:36:07', NULL, '20060725013241') , (NULL, 'w', '2004-01-10', '3', NULL, NULL, 'y', '2000-06-06 17:35:29', '3', '19:23:22'); INSERT IGNORE INTO PP_H VALUES ('u', NULL, '05:59:43', '8', 'c', '10:55:02', NULL, NULL, '1', '04:19:56') , ('k', 'm', '20041028235547', NULL, 's', '20081209023701', NULL, '2009', NULL, '2004') , ('j', 'm', '2004', '5', 'j', NULL, 'w', '2007-02-07 23:56:27', '8', '2000') , ('w', 'y', '2007', '3', 'q', '20020325043855', 'g', NULL, NULL, '14:03:36') , ('l', 'z', '2000-08-19', '5', 'o', '2000-04-12', 'm', '20040725133002', '6', '2002') , ('w', 'd', '20021022013216', NULL, 'x', '2002-11-14', 'p', '20011103000751', '8', '2000-03-24 12:20:11') , ('f', 'f', '2004', '9', 's', '2009', NULL, '05:41:15', NULL, '2002') , ('h', NULL, NULL, '3', 'j', '2001-03-23 14:37:06', 'r', NULL, '8', '20080207173308') , ('j', NULL, '20051005121943', NULL, 'p', '03:58:08', 'v', '2000', '1', '2001-07-15 04:03:07') , ('n', 'v', NULL, '4', NULL, '20020120235200', NULL, '2002', '6', '13:35:27'); INSERT IGNORE INTO PP_H VALUES ('z', 't', '20010526123331', NULL, 'h', '2008', 'x', '2005', '3', '20040310014347') , ('e', 'd', '20:57:44', '0', 'g', '2000', 'y', '05:12:46', '7', '20091010072012') , ('a', 'x', '20001023102707', '1', NULL, '2005', 'u', '2008', '2', '20081206113254') , ('x', 'd', NULL, '5', NULL, '2006', 'q', '2001', '7', '20061128130034') , (NULL, NULL, '17:15:23', '8', 'h', '20011018142610', 'm', NULL, '7', '20091103013121') , ('o', 't', '2009-02-19', '0', 'k', '20050125080154', 'r', '20080114220752', '2', '2000-05-15 17:17:24') , ('o', 't', '2002', '8', 'k', '2009-11-15', 'w', '2000', '3', '17:14:26') , ('m', NULL, NULL, '9', 'd', '2009-05-06', 'r', '20:09:59', '9', '2006') , ('b', 'g', '2000-11-01 06:04:00', '8', 'v', '20081108164817', NULL, NULL, '5', '13:27:38') , ('w', 'e', '2001', '0', 'd', '2006-01-08 21:16:01', 'c', '20000724181507', '8', '2006-03-20 05:43:17'); INSERT IGNORE INTO PP_H VALUES ('o', 'n', '20001224012900', NULL, 's', NULL, NULL, '2009-07-17', '6', '2005') , ('s', 'u', NULL, '3', NULL, '23:53:28', 'z', '20070122233204', '3', '2008') , (NULL, NULL, '2002-09-20 01:33:07', '8', 'v', '2005-06-19 14:03:47', 'r', '20010218180408', '8', '14:25:59') , ('o', 'h', '11:26:07', NULL, 's', '2007-05-07 02:59:32', 'c', NULL, NULL, NULL) , ('u', 'l', NULL, '9', 'f', '2009', 'r', '2005', '6', NULL) , (NULL, 'u', '2005-02-04 20:24:40', '5', 'h', '20030501070943', 'q', '2008', '6', '20090804112818') , ('d', 'l', '2000-11-07', '8', NULL, '2001-02-24 15:59:54', 'w', '20061012201954', '9', '2008-06-23') , ('z', 'b', '20000501044907', '2', 'c', '05:48:48', 'q', '20090214104902', '4', '20010511140951') , ('c', 'u', '2001-04-11 19:14:56', '2', 'o', '2005-12-24', NULL, NULL, '1', '2006-01-25 19:56:18') , ('y', 'w', '2005-09-14', NULL, 'y', '2008-12-20', 'e', '2002-01-10', '7', NULL); --enable_query_log --enable_warnings #SELECT * FROM PP_H WHERE ( ( ( `PP_H` . `varchar_5` >= 'j' ) OR `PP_H` . `varchar_5` IN ('q', 'r' ) ) OR `PP_H` . `int_signed` BETWEEN 3 AND ( 3 + 8 ) ); UPDATE `PP_H` SET `varchar_5` = 'z' WHERE ( ( ( `PP_H` . `varchar_5` >= 'j' ) OR `PP_H` . `varchar_5` IN ('q', 'r' ) ) OR `PP_H` . `int_signed` BETWEEN 3 AND ( 3 + 8 ) ); SELECT COUNT(*) FROM `PP_H` WHERE `varchar_5` = 'z'; DROP TABLE PP_H;