← 返回首页
删除MySQL表中某个字段重复数据的两种方式
发表时间：2023-02-14 11:14:59
删除MySQL表中某个字段重复数据的两种方式

删除MySQL表中某个字段重复数据的两种方式。

有以下测试数据：

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for pay_invoice
-- ----------------------------
DROP TABLE IF EXISTS `pay_invoice`;
CREATE TABLE `pay_invoice`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `flag` bit(1) NOT NULL,
  `modify_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `version` int NULL DEFAULT NULL,
  `attach` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mch_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `money` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `open_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `out_trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `pay_channel` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `pay_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sign` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 233 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pay_invoice
-- ----------------------------
INSERT INTO `pay_invoice` VALUES (101, '2023-02-04 21:43:52', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (102, '2023-02-04 21:44:08', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (103, '2023-02-04 21:44:24', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (104, '2023-02-04 21:44:55', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (105, '2023-02-04 21:47:56', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (106, '2023-02-04 21:54:16', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (107, '2023-02-04 21:54:32', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (108, '2023-02-04 21:54:48', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (109, '2023-02-04 21:55:19', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (110, '2023-02-04 21:57:57', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (111, '2023-02-04 21:58:20', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (112, '2023-02-04 22:08:21', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (113, '2023-02-04 22:17:58', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (114, '2023-02-04 22:28:22', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (115, '2023-02-04 22:47:59', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (116, '2023-02-04 22:58:23', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (117, '2023-02-04 23:18:00', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (118, '2023-02-04 23:28:24', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (119, '2023-02-04 23:34:16', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y15034671341907', '20230204145941efaab359afc544119c76efb362b485bf', 'wxpay', '4200001687202302041350441383', 'BD457A4CD6D65ED3C3425F8576A2DCE7', '2023-02-04 15:03:54');
INSERT INTO `pay_invoice` VALUES (120, '2023-02-04 23:48:01', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (121, '2023-02-04 23:58:25', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (122, '2023-02-05 00:04:17', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y15034671341907', '20230204145941efaab359afc544119c76efb362b485bf', 'wxpay', '4200001687202302041350441383', 'BD457A4CD6D65ED3C3425F8576A2DCE7', '2023-02-04 15:03:54');
INSERT INTO `pay_invoice` VALUES (123, '2023-02-05 00:18:05', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (124, '2023-02-05 00:28:28', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (125, '2023-02-05 00:48:02', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (126, '2023-02-05 00:58:26', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (127, '2023-02-05 02:34:17', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y15034671341907', '20230204145941efaab359afc544119c76efb362b485bf', 'wxpay', '4200001687202302041350441383', 'BD457A4CD6D65ED3C3425F8576A2DCE7', '2023-02-04 15:03:54');
INSERT INTO `pay_invoice` VALUES (128, '2023-02-05 03:04:18', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y15034671341907', '20230204145941efaab359afc544119c76efb362b485bf', 'wxpay', '4200001687202302041350441383', 'BD457A4CD6D65ED3C3425F8576A2DCE7', '2023-02-04 15:03:54');
INSERT INTO `pay_invoice` VALUES (129, '2023-02-05 03:18:06', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (130, '2023-02-05 03:28:29', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (131, '2023-02-05 03:48:03', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (132, '2023-02-05 03:58:27', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (133, '2023-02-05 06:18:07', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (134, '2023-02-05 06:28:30', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (135, '2023-02-05 06:48:04', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (136, '2023-02-05 06:58:28', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (137, '2023-02-05 08:34:18', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y15034671341907', '20230204145941efaab359afc544119c76efb362b485bf', 'wxpay', '4200001687202302041350441383', 'BD457A4CD6D65ED3C3425F8576A2DCE7', '2023-02-04 15:03:54');
INSERT INTO `pay_invoice` VALUES (138, '2023-02-05 09:04:18', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y15034671341907', '20230204145941efaab359afc544119c76efb362b485bf', 'wxpay', '4200001687202302041350441383', 'BD457A4CD6D65ED3C3425F8576A2DCE7', '2023-02-04 15:03:54');
INSERT INTO `pay_invoice` VALUES (139, '2023-02-05 09:18:08', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (140, '2023-02-05 09:28:31', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (141, '2023-02-05 09:48:05', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (142, '2023-02-05 09:58:28', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (143, '2023-02-05 14:34:19', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y15034671341907', '20230204145941efaab359afc544119c76efb362b485bf', 'wxpay', '4200001687202302041350441383', 'BD457A4CD6D65ED3C3425F8576A2DCE7', '2023-02-04 15:03:54');
INSERT INTO `pay_invoice` VALUES (144, '2023-02-05 15:18:09', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (145, '2023-02-05 15:28:33', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (146, '2023-02-05 15:48:06', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (147, '2023-02-05 15:58:29', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (148, '2023-02-05 21:18:10', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21471975198156', '2023020421432473d64980c30f46a68f4b6b54f3f6c310', 'wxpay', '4200001698202302046514108649', '3F918BA235C894CFACB389F99C74A785', '2023-02-04 21:47:41');
INSERT INTO `pay_invoice` VALUES (149, '2023-02-05 21:28:33', b'1', NULL, 0, 'attached', '1', '1611539741', '0.03', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21575181004329', '202302042153561a23a1e4ecd34a85909fb76900b0ca43', 'wxpay', '4200001702202302049016198107', '0224AC614106FF413235A903A22BEAB4', '2023-02-04 21:58:04');
INSERT INTO `pay_invoice` VALUES (150, '2023-02-12 18:18:36', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (151, '2023-02-12 18:18:52', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (152, '2023-02-12 18:19:08', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (153, '2023-02-12 18:19:39', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (154, '2023-02-12 18:22:40', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (155, '2023-02-12 18:32:41', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (156, '2023-02-12 18:52:42', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (157, '2023-02-12 19:22:43', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (158, '2023-02-12 19:43:12', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (159, '2023-02-12 19:43:28', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (160, '2023-02-12 19:43:44', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (161, '2023-02-12 19:44:15', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (162, '2023-02-12 19:47:15', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (163, '2023-02-12 19:52:44', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (164, '2023-02-12 19:57:16', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (165, '2023-02-12 20:17:17', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (166, '2023-02-12 20:22:45', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (167, '2023-02-12 20:35:05', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (168, '2023-02-12 20:35:21', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (169, '2023-02-12 20:35:37', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (170, '2023-02-12 20:36:08', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (171, '2023-02-12 20:39:09', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (172, '2023-02-12 20:47:18', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (173, '2023-02-12 20:49:10', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (174, '2023-02-12 20:52:47', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (175, '2023-02-12 21:09:11', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (176, '2023-02-12 21:17:19', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (177, '2023-02-12 21:22:46', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (178, '2023-02-12 21:39:12', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (179, '2023-02-12 21:47:20', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (180, '2023-02-12 21:47:42', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (181, '2023-02-12 21:47:58', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (182, '2023-02-12 21:48:14', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (183, '2023-02-12 21:48:45', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (184, '2023-02-12 21:51:46', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (185, '2023-02-12 22:01:47', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (186, '2023-02-12 22:09:13', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (187, '2023-02-12 22:17:23', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (188, '2023-02-12 22:21:48', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (189, '2023-02-12 22:39:14', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (190, '2023-02-12 22:47:21', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (191, '2023-02-12 22:51:49', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (192, '2023-02-12 23:09:17', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (193, '2023-02-12 23:21:50', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (194, '2023-02-12 23:39:15', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (195, '2023-02-12 23:51:51', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (196, '2023-02-12 23:52:48', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (197, '2023-02-13 00:21:54', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (198, '2023-02-13 00:22:46', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (199, '2023-02-13 00:51:52', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (200, '2023-02-13 01:17:24', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (201, '2023-02-13 01:47:22', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (202, '2023-02-13 02:09:18', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (203, '2023-02-13 02:39:16', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (204, '2023-02-13 02:52:49', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (205, '2023-02-13 03:21:55', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (206, '2023-02-13 03:22:47', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (207, '2023-02-13 03:51:53', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (208, '2023-02-13 04:17:26', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (209, '2023-02-13 04:47:23', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (210, '2023-02-13 05:09:19', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (211, '2023-02-13 05:39:17', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (212, '2023-02-13 05:52:51', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (213, '2023-02-13 06:21:56', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (214, '2023-02-13 06:22:48', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (215, '2023-02-13 06:51:53', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (216, '2023-02-13 07:17:27', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (217, '2023-02-13 07:47:24', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (218, '2023-02-13 08:09:20', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (219, '2023-02-13 08:39:18', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (220, '2023-02-13 09:21:57', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (221, '2023-02-13 09:51:54', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (222, '2023-02-13 11:52:51', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (223, '2023-02-13 12:22:49', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (224, '2023-02-13 13:17:28', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (225, '2023-02-13 13:47:25', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (226, '2023-02-13 14:09:21', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (227, '2023-02-13 14:39:18', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (228, '2023-02-13 15:21:58', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (229, '2023-02-13 15:51:55', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');
INSERT INTO `pay_invoice` VALUES (230, '2023-02-13 17:52:52', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y18222710601960', '20230212181821cc10cfd1a99541eabcac06e3d56a8b23', 'wxpay', '4200001795202302121421380955', 'A693CB5602673F7A88B23190E1D06026', '2023-02-12 18:22:35');
INSERT INTO `pay_invoice` VALUES (231, '2023-02-13 19:17:29', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y19470418629574', '202302121942574442392570974ba8b992c3c15b8d36fc', 'wxpay', '4200001708202302123748515605', '138EBBE34E4A2F018569062A0C470319', '2023-02-12 19:47:11');
INSERT INTO `pay_invoice` VALUES (232, '2023-02-13 20:09:22', b'1', NULL, 0, 'attached', '1', '1611539741', '0.01', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y20385723987205', '20230212203451aab5f3da5b0244a88d9fa772bda75a9b', 'wxpay', '4200001799202302123675449229', 'DBC2B921BAC920DB7FE69026869687D0', '2023-02-12 20:39:05');
INSERT INTO `pay_invoice` VALUES (233, '2023-02-13 21:21:59', b'1', NULL, 0, 'attached', '1', '1611539741', '0.02', 'oXHSA4jFuXI3MQThilNAMk2X7Y9g', 'Y21513349841952', '202302122147279c34989b6b6c41b0a2c43d87597feb58', 'wxpay', '4200001788202302127434485237', '55BA99A8E5316A7B13A4A470FE6FCC7F', '2023-02-12 21:51:42');

SET FOREIGN_KEY_CHECKS = 1;

1.传统子查询方式。

DELETE
p
FROM
pay_invoice p
WHERE p.id NOT IN (
    SELECT IFNULL(MIN(id),p.id)
    FROM (
        SELECT min(id) id,d.out_trade_no
        FROM pay_invoice d
        GROUP BY d.out_trade_no 
        HAVING COUNT(1)>1
    ) as b
    WHERE p.out_trade_no = b.out_trade_no
)

sql几个关键点解释下：

WHERE p.out_trade_no = b.out_trade_no 使用相关子查询将外表的数据代入内表。 为什么这么写IFNULL(MIN(id),p.id) :由于查不到数据返回N/A(Not Applicable，不适用的意思),需要使用聚合函数将其转换为null来判断。p.id就是外表的id。不重复的数据就返回自身id，（这是不删除不重复数据的关键）这样就不会删除不重复的数据了。

2.使用窗口函数

mysql8.0以上版本支持窗口函数。

DELETE
FROM pay_invoice 
WHERE id in (
    SELECT id
    FROM(
        SELECT *
        FROM (
            SELECT ROW_NUMBER() OVER w AS row_num,out_trade_no,id
            FROM pay_invoice   
            WINDOW w AS (PARTITION BY out_trade_no ORDER BY id)
        )t
        WHERE row_num >1
    )e
)

注意：当然不建议直接删除数据，可以逻辑删除，改成相应的update语句。