1、Create table CREATE TABLE `question` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `content` text, `answer` text, `fingerprint` bigint(20) DEFAULT NULL, `ctime` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT 'creation time', `utime` timestamp(6) NOT NULL DEFAULT '1970-01-01 08:00:01.000000' ON UPDATE CURRENT_TIMESTAMP(6) COMMENT 'Real time update time', PRIMARY KEY (`id`), UNIQUE KEY `fingerprint` (`fingerprint`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; CREATE TABLE `tmp_id` ( `id` bigint(20) DEFAULT NULL, `fingerprint` bigint(20) DEFAULT NULL, `batch` int(11) DEFAULT NULL, `tag` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 2、Import Data use test_feng; INSERT INTO `question` VALUES (1,'
','See answer above+698859341222985088+92104',698859341222985088,'2023-09-05 18:32:26.457972','2023-10-08 15:28:25.458286'),(2,'
','See answer above+698859341222070538+11996',698859341222070538,'2023-09-05 17:44:58.056251','2023-09-07 19:44:47.653207'),(3,'
',NULL,698859341221854388,'2023-09-05 17:44:45.041058','2023-09-07 18:49:36.138632'),(4,'
','See answer above+698859341219923788+39204',698859341219923788,'2023-08-15 17:18:09.693945','2023-09-07 19:44:47.449329'),(5,'
','See answer above+698859341220645388+286',698859341220645388,'2023-09-05 17:40:25.606946','2023-09-07 19:44:47.488986'),(6,'
',NULL,698859341219273513,'2023-08-14 18:30:44.775196','2023-09-07 18:49:36.138632'),(7,'
',NULL,698859341222886288,'2023-09-05 17:46:02.843500','2023-09-07 18:49:36.138632'),(8,'
','See answer above+698859341220708213+33408',698859341220708213,'2023-09-05 17:40:32.403540','2023-10-08 15:28:25.584390'),(9,'
','See answer above+698859341219746638+48895',698859341219746638,'2023-08-14 19:02:32.571480','2023-10-08 15:28:25.613523'),(10,'
','See answer above+698859341222357138+86888',698859341222357138,'2023-09-05 17:45:17.538188','2023-10-08 15:28:25.627171'),(11,'
','See answer above+698859341219325163+34592',698859341219325163,'2023-08-14 18:32:27.747098','2023-09-07 19:44:47.635405'),(12,'
','See answer above+698859341222541713+48803',698859341222541713,'2023-09-05 17:45:31.332849','2023-09-07 19:44:47.446047'),(13,'
',NULL,698859341222723713,'2023-09-05 17:45:46.428179','2023-09-07 18:49:36.138632'),(14,'
','See answer above+698859341220468238+75373',698859341220468238,'2023-09-05 17:40:06.352991','2023-09-07 19:44:47.658748'),(15,'
','See answer above+698859341221288663+36461',698859341221288663,'2023-09-05 17:41:35.888135','2023-09-07 19:44:47.643343'),(16,'
',NULL,698859341221085188,'2023-09-05 17:41:13.321419','2023-09-07 18:49:36.138632'),(17,'
',NULL,698859341221648888,'2023-09-05 17:42:17.220748','2023-09-07 18:49:36.138632'),(18,'
','See answer above+698859341221523988+406',698859341221523988,'2023-09-05 17:42:02.390459','2023-09-07 19:44:47.623002'),(19,'
',NULL,698859341219526288,'2023-08-14 18:44:42.486630','2023-09-07 18:49:36.138632'),(20,'
','See answer above+698859341219716588+76524',698859341219716588,'2023-08-14 19:02:29.625329','2023-10-08 15:28:25.500643'),(21,'
',NULL,698859341220292288,'2023-09-05 16:40:50.427518','2023-09-07 18:49:36.138632'),(22,'
','See answer above+698859341221608538+95723',698859341221608538,'2023-09-05 17:42:12.362389','2023-09-07 19:44:47.595772'),(23,'
','See answer above+698859341219378038+60236',698859341219378038,'2023-08-14 18:32:33.671140','2023-10-08 15:28:25.611882'),(24,'
','See answer above+5590874729758409700+77887',698859341219801213,'2023-08-15 17:17:51.703111','2023-09-07 18:49:36.138632'),(25,'
','See answer above+698859341222526663+96451',698859341222526663,'2023-09-05 17:45:30.172681','2023-09-07 19:44:47.618019'),(26,'
','See answer above+698859341220977763+71158',698859341220977763,'2023-09-05 17:41:01.362432','2023-10-08 15:28:25.582306'),(27,'
',NULL,698859341221496738,'2023-09-05 17:41:59.157009','2023-09-07 18:49:36.138632'),(28,'
','See answer above+698859341219211363+76990',698859341219211363,'2023-08-14 18:30:37.378438','2023-10-08 15:28:25.614774'),(29,'
','See answer above+698859341219229438+58913',698859341219229438,'2023-08-14 18:30:39.547004','2023-10-08 15:28:25.509798'),(30,'
','See answer above+698859341220265538+98094',698859341220265538,'2023-09-05 16:40:46.209292','2023-09-07 19:44:47.683227'),(31,'
','See answer above+698859341221900638+35683',698859341221900638,'2023-09-05 17:44:47.655036','2023-09-07 19:44:47.612657'),(32,'
','See answer above+698859341219416788+51207',698859341219416788,'2023-08-14 18:32:38.032700','2023-10-08 15:28:25.406017'),(33,'
','See answer above+698859341223359913+41560',698859341223359913,'2023-09-05 18:43:43.430193','2023-09-07 19:44:47.642538'),(34,'
','See answer above+698859341220907388+22660',698859341220907388,'2023-09-05 17:40:53.951533','2023-09-07 19:44:47.546039'),(35,'
',NULL,698859341221659063,'2023-09-05 17:42:18.528625','2023-09-07 18:49:36.138632'),(36,'
','See answer above+698859341220065038+366',698859341220065038,'2023-09-05 16:31:25.914876','2023-09-07 19:44:47.599030'),(37,'
',NULL,698859341220856538,'2023-09-05 17:40:48.251006','2023-09-07 18:49:36.138632'),(38,'
','See answer above+698859341223094838+50345',698859341223094838,'2023-09-05 18:33:59.301688','2023-09-07 19:44:47.562243'),(39,'
',NULL,698859341219391513,'2023-08-14 18:32:35.010459','2023-09-07 18:49:36.138632'),(40,'
','See answer above+698859341219679613+48010',698859341219679613,'2023-08-14 18:59:08.020811','2023-09-07 19:44:47.679515'),(41,'
',NULL,698859341219643313,'2023-08-14 18:50:47.453138','2023-09-07 18:49:36.138632'),(42,'
',NULL,698859341220240388,'2023-09-05 16:40:42.290549','2023-09-07 18:49:36.138632'),(43,'
',NULL,698859341221953788,'2023-09-05 17:44:50.829333','2023-09-07 18:49:36.138632'),(44,'
','See answer above+698859341221313113+97585',698859341221313113,'2023-09-05 17:41:38.637426','2023-10-08 15:28:25.553670'),(45,'
','See answer above+698859341220977013+77579',698859341220977013,'2023-09-05 17:41:01.319002','2023-10-08 15:28:25.627284'),(46,'
','See answer above+698859341219665113+54335',698859341219665113,'2023-08-14 18:58:02.577046','2023-10-08 15:28:25.517399'),(47,'
',NULL,698859341223229463,'2023-09-05 18:37:56.153740','2023-09-07 18:49:36.138632'),(48,'
','See answer above+698859341222363113+91937',698859341222363113,'2023-09-05 17:45:18.004652','2023-09-07 19:44:47.685777'),(49,'
','See answer above+698859341221540338+19390',698859341221540338,'2023-09-05 17:42:04.320264','2023-09-07 19:44:47.441003'),(50,'
',NULL,698859341220840163,'2023-09-05 17:40:46.434826','2023-09-07 18:49:36.138632'),(51,'
',NULL,698859341222923063,'2023-09-05 17:46:07.015227','2023-09-07 18:49:36.138632'),(52,'
','See answer above+698859341221583013+10152',698859341221583013,'2023-09-05 17:42:09.270238','2023-10-08 15:28:25.412505'),(53,'
','See answer above+698859341222751338+32175',698859341222751338,'2023-09-05 17:45:48.958720','2023-10-08 15:28:25.620432'),(54,'
','See answer above+698859341219679463+20529',698859341219679463,'2023-08-14 18:59:08.093315','2023-10-08 15:28:25.558594'),(55,'
','See answer above+698859341221383888+68615',698859341221383888,'2023-09-05 17:41:46.534907','2023-10-08 15:28:25.442256'),(56,'
','See answer above+-55908747297774343+75109',698859341222179288,'2023-09-05 17:45:05.092415','2023-09-07 18:49:36.138632'),(57,'
',NULL,698859341220916413,'2023-09-05 17:40:54.880095','2023-09-07 18:49:36.138632'),(58,'
',NULL,698859341219932588,'2023-08-15 17:18:10.718590','2023-09-07 18:49:36.138632'),(59,'
','See answer above+698859341219561888+93997',698859341219561888,'2023-08-14 18:50:38.554404','2023-10-08 15:28:25.383441'),(60,'
',NULL,698859341219651588,'2023-08-14 18:50:48.235388','2023-09-07 18:49:36.138632'),(61,'
','See answer above+698859341222567913+61474',698859341222567913,'2023-09-05 17:45:33.387380','2023-10-08 15:28:25.497997'),(62,'
','See answer above+698859341221478888+36863',698859341221478888,'2023-09-05 17:41:57.075092','2023-09-07 19:44:47.676855'),(63,'
',NULL,698859341221020188,'2023-09-05 17:41:06.203952','2023-09-07 18:49:36.138632'),(64,'
','See answer above+5590874729769788100+18135',698859341221223513,'2023-09-05 17:41:28.452205','2023-09-07 18:49:36.138632'),(65,'
','See answer above+698859341221459088+19459',698859341221459088,'2023-09-05 17:41:54.854323','2023-10-08 15:28:25.483537'),(66,'
',NULL,698859341222499013,'2023-09-05 17:45:28.074065','2023-09-07 18:49:36.138632'),(67,'
',NULL,698859341219413763,'2023-08-14 18:32:37.531493','2023-09-07 18:49:36.138632'),(68,'
',NULL,698859341222606313,'2023-09-05 17:45:36.428628','2023-09-07 18:49:36.138632'),(69,'
','See answer above+698859341220290813+82284',698859341220290813,'2023-09-05 16:40:50.189676','2023-10-08 15:28:25.566491'),(70,'
','See answer above+698859341219716088+33554',698859341219716088,'2023-08-14 19:02:29.639832','2023-10-08 15:28:25.452876'),(71,'
',NULL,698859341220415013,'2023-09-05 17:38:49.002421','2023-09-07 18:49:36.138632'),(72,'
','See answer above+698859341221997188+50672',698859341221997188,'2023-09-05 17:44:53.473986','2023-09-07 19:44:47.616553'),(73,'
','See answer above+698859341221842538+20017',698859341221842538,'2023-09-05 17:44:44.292558','2023-10-08 15:28:25.415551'),(74,'
','See answer above+-3450319880119879358+15038',-3450319880119879358,'2023-09-07 14:53:22.686866','2023-10-08 15:28:25.571941'),(75,'
','See answer above+698859341220279413+52390',698859341220279413,'2023-09-05 16:40:48.379952','2023-10-08 15:28:25.507771'),(76,'
','See answer above+698859341221939588+15793',698859341221939588,'2023-09-05 17:44:49.992906','2023-09-07 19:44:47.526335'),(77,'
','See answer above+698859341219575963+61508',698859341219575963,'2023-08-14 18:50:40.255519','2023-10-08 15:28:25.535010'),(78,'
','See answer above+698859341219531663+71466',698859341219531663,'2023-08-14 18:44:43.317076','2023-10-08 15:28:25.450921'),(79,'
',NULL,698859341219903338,'2023-08-15 17:18:06.898618','2023-09-07 18:49:36.138632'),(80,'
',NULL,698859341220933163,'2023-09-05 17:40:56.666736','2023-09-07 18:49:36.138632'),(81,'
',NULL,698859341220148913,'2023-09-05 16:39:49.402207','2023-09-07 18:49:36.138632'),(82,'
',NULL,698859341221432238,'2023-09-05 17:41:51.940011','2023-09-07 18:49:36.138632'),(83,'
','See answer above+698859341220619413+77712',698859341220619413,'2023-09-05 17:40:22.978416','2023-09-07 19:44:47.677401'),(84,'
','See answer above+698859341223051263+71168',698859341223051263,'2023-09-05 18:31:00.168245','2023-10-08 15:28:25.445228'),(85,'
',NULL,698859341222093338,'2023-09-05 17:44:59.460115','2023-09-07 18:49:36.138632'),(86,'
',NULL,698859341221205238,'2023-09-05 17:41:26.461365','2023-09-07 18:49:36.138632'),(87,'
',NULL,-7110726195817226063,'2023-09-07 13:20:09.737787','1970-01-01 08:00:01.000000'),(88,'
',NULL,698859341222802663,'2023-09-05 17:45:53.943455','2023-09-07 18:49:36.138632'),(89,'
',NULL,698859341221330413,'2023-09-05 17:41:40.550948','2023-09-07 18:49:36.138632'),(90,'
','See answer above+698859341222333488+61984',698859341222333488,'2023-09-05 17:45:15.823151','2023-09-07 19:44:47.614922'),(91,'
','See answer above+698859341219780913+47989',698859341219780913,'2023-08-14 19:02:36.142162','2023-10-08 15:28:25.491665'),(92,'
','See answer above+698859341221179613+37539',698859341221179613,'2023-09-05 17:41:23.597852','2023-09-07 19:44:47.482008'),(93,'
',NULL,698859341220679488,'2023-09-05 17:40:29.312264','2023-09-07 18:49:36.138632'),(94,'
','See answer above+698859341221603838+87001',698859341221603838,'2023-09-05 17:42:11.814746','2023-10-08 15:28:25.486815'),(95,'
','See answer above+698859341221248813+71461',698859341221248813,'2023-09-05 17:41:31.560999','2023-10-08 15:28:25.518133'),(96,'
','See answer above+698859341223280188+93755',698859341223280188,'2023-09-05 18:43:31.027900','2023-09-07 19:44:47.671768'),(97,'
','See answer above+698859341222635663+62115',698859341222635663,'2023-09-05 17:45:38.844012','2023-10-08 15:28:25.592620'),(98,'
','See answer above+698859341221373788+26225',698859341221373788,'2023-09-05 17:41:45.406051','2023-09-07 19:44:47.551668'),(99,'
',NULL,698859341221795913,'2023-09-05 17:44:41.738459','2023-09-07 18:49:36.138632'),(100,'
',NULL,698859341221236563,'2023-09-05 17:41:30.032387','2023-09-07 18:49:36.138632'),(101,'
',NULL,698859341219659513,'2023-08-14 18:58:01.922691','2023-09-07 18:49:36.138632'),(102,'
',NULL,698859341219241263,'2023-08-14 18:30:40.787558','2023-09-07 18:49:36.138632'),(103,'
','See answer above+698859341223310513+3036',698859341223310513,'2023-09-05 18:43:34.357987','2023-10-08 15:28:25.472967'),(104,'
','See answer above+698859341219697388+58714',698859341219697388,'2023-08-14 19:02:27.552603','2023-09-07 19:44:47.665305'),(105,'
','See answer above+698859341220787363+87061',698859341220787363,'2023-09-05 17:40:40.776019','2023-09-07 19:44:47.468056'),(106,'
','See answer above+698859341221102513+25283',698859341221102513,'2023-09-05 17:41:15.028024','2023-10-08 15:28:25.395044'),(107,'
','See answer above+-3299556028677098222+65685',-3299556028677098222,'2023-09-07 13:20:29.197413','2023-10-08 15:28:25.595042'),(108,'
','See answer above+698859341221337588+85697',698859341221337588,'2023-09-05 17:41:41.357101','2023-10-08 15:28:25.421159'),(109,'
','See answer above+698859341222997938+12633',698859341222997938,'2023-09-05 18:30:33.724229','2023-09-07 19:44:47.554327'),(110,'
','See answer above+698859341220090388+13235',698859341220090388,'2023-09-05 16:31:30.020879','2023-10-08 15:28:25.506513'),(111,'
','See answer above+698859341221473588+36060',698859341221473588,'2023-09-05 17:41:56.505962','2023-09-07 19:44:47.586555'),(112,'
','See answer above+698859341222092238+94507',698859341222092238,'2023-09-05 17:44:59.409588','2023-10-08 15:28:25.592348'),(113,'
',NULL,698859341219164513,'2023-08-14 18:25:26.918905','2023-09-07 18:49:36.138632'),(114,'
','See answer above+698859341221224988+29323',698859341221224988,'2023-09-05 17:41:28.681667','2023-09-07 19:44:47.507485'),(115,'
',NULL,698859341223254163,'2023-09-05 18:39:43.649008','2023-09-07 18:49:36.138632'),(116,'
','See answer above+698859341221002688+23027',698859341221002688,'2023-09-05 17:41:04.137150','2023-09-07 19:44:47.628379'),(117,'
',NULL,698859341220219088,'2023-09-05 16:40:00.538146','2023-09-07 18:49:36.138632'),(118,'
',NULL,698859341222126413,'2023-09-05 17:45:01.591982','2023-09-07 18:49:36.138632'),(119,'
','See answer above+-3092833030787230894+93523',-3092833030787230894,'2023-09-07 13:20:22.721707','2023-10-08 15:28:25.470343'),(120,'
','See answer above+698859341221767488+52653',698859341221767488,'2023-09-05 17:44:40.120862','2023-09-07 19:44:47.491449'),(121,'
','See answer above+-3052738410012523296+19515',-3052738410012523296,'2023-09-07 13:20:01.614283','2023-10-08 15:28:25.423438'),(122,'
','See answer above+698859341221969188+78594',698859341221969188,'2023-09-05 17:44:51.767122','2023-09-07 19:44:47.626795'),(123,'
','See answer above+698859341223000838+69954',698859341223000838,'2023-09-05 18:30:34.752267','2023-09-07 19:44:47.557257'),(124,'
','See answer above+698859341219923588+61817',698859341219923588,'2023-08-15 17:18:09.598967','2023-09-07 19:44:47.697195'),(125,'
','See answer above+698859341220704663+31832',698859341220704663,'2023-09-05 17:40:32.124557','2023-09-07 19:44:47.507575'),(126,'
',NULL,698859341221512938,'2023-09-05 17:42:01.053568','2023-09-07 18:49:36.138632'),(127,'
','See answer above+698859341222875238+57597',698859341222875238,'2023-09-05 17:46:01.611114','2023-10-08 15:28:25.409745'),(128,'
',NULL,698859341222101263,'2023-09-05 17:44:59.979177','2023-09-07 18:49:36.138632'),(129,'
',NULL,698859341219774263,'2023-08-14 19:02:35.456893','2023-09-07 18:49:36.138632'),(130,'
',NULL,698859341220820313,'2023-09-05 17:40:44.215326','2023-09-07 18:49:36.138632'),(131,'
','See answer above+-5880006650562827949+71506',-5880006650562827949,'2023-09-07 13:20:18.390727','2023-10-08 15:28:25.417376'),(132,'
','See answer above+698859341219264963+14823',698859341219264963,'2023-08-14 18:30:43.710275','2023-09-07 19:44:47.460576'),(133,'
','See answer above+698859341221296113+60911',698859341221296113,'2023-09-05 17:41:36.657182','2023-10-08 15:28:25.461730'),(134,'
',NULL,698859341223284513,'2023-09-05 18:43:31.502328','2023-09-07 18:49:36.138632'),(135,'
','See answer above+698859341219842863+82083',698859341219842863,'2023-08-15 17:17:57.374877','2023-10-08 15:28:25.529572'),(136,'
','See answer above+-3778186300963807214+90729',-3778186300963807214,'2023-09-07 13:20:01.808804','2023-09-07 19:44:47.657063'),(137,'
',NULL,698859341221082888,'2023-09-05 17:41:13.051006','2023-09-07 18:49:36.138632'),(138,'
','See answer above+698859341222955963+1832',698859341222955963,'2023-09-05 17:46:10.966808','2023-10-08 15:28:25.592205'),(139,'
','See answer above+698859341219438963+33519',698859341219438963,'2023-08-14 18:44:29.039377','2023-09-07 19:44:47.457487'),(140,'
','See answer above+698859341223118013+12779',698859341223118013,'2023-09-05 18:34:36.831808','2023-10-08 15:28:25.601445'),(141,'
',NULL,698859341219530238,'2023-08-14 18:44:43.100803','2023-09-07 18:49:36.138632'),(142,'
','See answer above+698859341221263338+94889',698859341221263338,'2023-09-05 17:41:33.192813','2023-10-08 15:28:25.631625'),(143,'
','See answer above+698859341221517763+88149',698859341221517763,'2023-09-05 17:42:01.639997','2023-09-07 19:44:47.543344'),(144,'
','See answer above+698859341222592413+29776',698859341222592413,'2023-09-05 17:45:35.322466','2023-10-08 15:28:25.406396'),(145,'
','See answer above+698859341222851063+91981',698859341222851063,'2023-09-05 17:45:58.988889','2023-10-08 15:28:25.410169'),(146,'
',NULL,698859341219197213,'2023-08-14 18:30:35.648821','2023-09-07 18:49:36.138632'),(147,'
','See answer above+698859341221557813+42356',698859341221557813,'2023-09-05 17:42:06.314984','2023-09-07 19:44:47.486019'),(148,'
',NULL,698859341222410438,'2023-09-05 17:45:21.471525','2023-09-07 18:49:36.138632'),(149,'
','See answer above+698859341222363613+21490',698859341222363613,'2023-09-05 17:45:18.045915','2023-09-07 19:44:47.613019'),(150,'
',NULL,698859341220015513,'2023-09-05 16:28:22.527989','2023-09-07 18:49:36.138632'),(151,'
',NULL,698859341220377363,'2023-09-05 17:38:45.431632','2023-09-07 18:49:36.138632'),(152,'
',NULL,698859341222606988,'2023-09-05 17:45:36.484449','2023-09-07 18:49:36.138632'),(153,'
','See answer above+698859341222856163+765',698859341222856163,'2023-09-05 17:45:59.539668','2023-09-07 19:44:47.620007'),(154,'
',NULL,698859341220277438,'2023-09-05 16:40:48.128256','2023-09-07 18:49:36.138632'),(155,'
','See answer above+698859341222406563+89450',698859341222406563,'2023-09-05 17:45:21.185094','2023-10-08 15:28:25.563204'),(156,'
','See answer above+698859341220667713+95355',698859341220667713,'2023-09-05 17:40:27.936141','2023-09-07 19:44:47.544439'),(157,'
','See answer above+719975359453870400+18864',719975359453870400,'2023-09-07 06:44:01.710437','2023-10-08 15:28:25.393843'),(158,'
',NULL,698859341220137863,'2023-09-05 16:31:37.530887','2023-09-07 18:49:36.138632'),(159,'
','See answer above+698859341220241113+79876',698859341220241113,'2023-09-05 16:40:42.426964','2023-10-08 15:28:25.587576'),(160,'
','See answer above+698859341223095463+49777',698859341223095463,'2023-09-05 18:34:26.453679','2023-09-07 19:44:47.609570'),(161,'
','See answer above+698859341220298438+37297',698859341220298438,'2023-09-05 16:40:51.394704','2023-09-07 19:44:47.655833'),(162,'
','See answer above+698859341220383538+16998',698859341220383538,'2023-09-05 17:38:46.067627','2023-10-08 15:28:25.613557'),(163,'
',NULL,698859341222769413,'2023-09-05 17:45:50.670932','2023-09-07 18:49:36.138632'),(164,'
',NULL,698859341222025313,'2023-09-05 17:44:55.149285','2023-09-07 18:49:36.138632'),(165,'
',NULL,698859341222490013,'2023-09-05 17:45:27.368375','2023-09-07 18:49:36.138632'),(166,'
','See answer above+698859341219335388+39350',698859341219335388,'2023-08-14 18:32:28.714658','2023-09-07 19:44:47.587504'),(167,'
',NULL,698859341220670638,'2023-09-05 17:40:28.278085','2023-09-07 18:49:36.138632'),(168,'
',NULL,698859341219273138,'2023-08-14 18:30:44.636651','2023-09-07 18:49:36.138632'),(169,'
','See answer above+698859341223184538+54680',698859341223184538,'2023-09-05 18:37:47.051746','2023-09-07 19:44:47.533895'),(170,'
','See answer above+698859341220224038+85576',698859341220224038,'2023-09-05 16:40:01.315271','2023-09-07 19:44:47.538768'),(171,'
','See answer above+698859341222211463+46580',698859341222211463,'2023-09-05 17:45:07.229892','2023-09-07 19:44:47.696995'),(172,'
','See answer above+698859341223303813+94725',698859341223303813,'2023-09-05 18:43:33.741028','2023-10-08 15:28:25.431433'),(173,'
',NULL,608791971592583520,'2023-09-07 06:44:01.376327','2023-09-07 18:49:36.138632'),(174,'
',NULL,698859341221087663,'2023-09-05 17:41:13.582743','2023-09-07 18:49:36.138632'),(175,'
',NULL,698859341220782363,'2023-09-05 17:40:40.259272','2023-09-07 18:49:36.138632'),(176,'
',NULL,698859341221727213,'2023-09-05 17:44:37.883948','2023-09-07 18:49:36.138632'),(177,'
',NULL,-7755910647778324744,'2023-09-07 13:20:13.765030','1970-01-01 08:00:01.000000'),(178,'
','See answer above+698859341222781488+90162',698859341222781488,'2023-09-05 17:45:51.844393','2023-09-07 19:44:47.594895'),(179,'
','See answer above+698859341221218838+87772',698859341221218838,'2023-09-05 17:41:27.932050','2023-10-08 15:28:25.510041'),(180,'
',NULL,698859341222713113,'2023-09-05 17:45:45.488796','2023-09-07 18:49:36.138632'),(181,'
','See answer above+698859341222799313+69875',698859341222799313,'2023-09-05 17:45:53.604695','2023-10-08 15:28:25.519657'),(182,'
',NULL,698859341222905263,'2023-09-05 17:46:04.963814','2023-09-07 18:49:36.138632'),(183,'
',NULL,698859341222957463,'2023-09-05 17:46:11.149137','2023-09-07 18:49:36.138632'),(184,'
','See answer above+698859341219380538+29410',698859341219380538,'2023-08-14 18:32:34.209347','2023-10-08 15:28:25.617320'),(185,'
',NULL,698859341222234313,'2023-09-05 17:45:08.793022','2023-09-07 18:49:36.138632'),(186,'
','See answer above+698859341219595263+15927',698859341219595263,'2023-08-14 18:50:41.998453','2023-09-07 19:44:47.438323'),(187,'
','See answer above+698859341221854713+30500',698859341221854713,'2023-09-05 17:44:45.037172','2023-09-07 19:44:47.582976'),(188,'
','See answer above+698859341219517988+34096',698859341219517988,'2023-08-14 18:44:41.195293','2023-10-08 15:28:25.560904'),(189,'
','See answer above+698859341220595838+16853',698859341220595838,'2023-09-05 17:40:20.601400','2023-10-08 15:28:25.454147'),(190,'
','See answer above+698859341222157088+51466',698859341222157088,'2023-09-05 17:45:03.613746','2023-10-08 15:28:25.605401'),(191,'
',NULL,698859341223227988,'2023-09-05 18:37:56.430636','2023-09-07 18:49:36.138632'),(192,'
',NULL,698859341221104063,'2023-09-05 17:41:15.169718','2023-09-07 18:49:36.138632'),(193,'
',NULL,698859341219452863,'2023-08-14 18:44:31.107006','2023-09-07 18:49:36.138632'),(194,'
','See answer above+698859341221948988+16468',698859341221948988,'2023-09-05 17:44:50.530062','2023-10-08 15:28:25.623061'),(195,'
',NULL,698859341220093838,'2023-09-05 16:31:30.522873','2023-09-07 18:49:36.138632'),(196,'
','See answer above+-6992983919378045252+3714',-6992983919378045252,'2023-09-07 14:53:22.487182','2023-10-08 15:28:25.513841'),(197,'
','See answer above+698859341220382063+55137',698859341220382063,'2023-09-05 17:38:45.983561','2023-09-07 19:44:47.499029'),(198,'
','See answer above+698859341219238038+91071',698859341219238038,'2023-08-14 18:30:40.457276','2023-09-07 19:44:47.625654'),(199,'
','See answer above+698859341221721788+32342',698859341221721788,'2023-09-05 17:44:37.618203','2023-09-07 19:44:47.664187'),(200,'
','See answer above+698859341221516188+51456',698859341221516188,'2023-09-05 17:42:01.467313','2023-09-07 19:44:47.499022'); use test_feng; INSERT INTO `tmp_id` VALUES (202,-6824736969193673268,NULL,1),(142,698859341221263338,NULL,0),(204,-1963237498797653934,NULL,1),(14,698859341220468238,NULL,0),(206,-4859666880333726982,NULL,1),(199,698859341221721788,NULL,0),(208,-5518157540397653353,NULL,1),(46,698859341219665113,NULL,0),(210,-7908802077836757862,NULL,1),(151,698859341220377363,NULL,0),(212,-3280682467309819505,NULL,1),(115,698859341223254163,NULL,0),(214,-6488547584794618396,NULL,1),(75,698859341220279413,NULL,0),(216,-2933968456182006391,NULL,1),(164,698859341222025313,NULL,0),(218,-1523916857303714795,NULL,1),(38,698859341223094838,NULL,0),(220,-6289060223188205606,NULL,1),(45,698859341220977013,NULL,0),(222,-5510460118561300845,NULL,1),(157,719975359453870400,NULL,0),(224,-2247241073967007283,NULL,1),(78,698859341219531663,NULL,0),(226,-4177313808021030211,NULL,1),(162,698859341220383538,NULL,0),(228,-6437666055424506733,NULL,1),(168,698859341219273138,NULL,0),(230,-7452004675098436078,NULL,1),(92,698859341221179613,NULL,0),(232,-5671355973865306157,NULL,1),(128,698859341222101263,NULL,0),(234,-4943249126168852220,NULL,1),(52,698859341221583013,NULL,0),(236,-3317676326210204574,NULL,1),(177,-7755910647778324744,NULL,0),(238,-7303606844652800355,NULL,1),(61,698859341222567913,NULL,0),(240,-7811086316344651359,NULL,1),(23,698859341219378038,NULL,0),(242,-3955829231582690673,NULL,1),(137,698859341221082888,NULL,0),(244,-4956187183248803207,NULL,1),(64,698859341221223513,NULL,0),(246,-1589798219956855267,NULL,1),(154,698859341220277438,NULL,0),(248,-6411731672558811788,NULL,1),(173,608791971592583520,NULL,0),(250,-4111047953361843549,NULL,1),(56,698859341222179288,NULL,0),(252,-4326400129320291036,NULL,1),(94,698859341221603838,NULL,0),(254,-3483953628666640434,NULL,1),(55,698859341221383888,NULL,0),(256,-7291633875781879755,NULL,1),(55,698859341221383888,NULL,0),(258,-7449898583002296337,NULL,1),(178,698859341222781488,NULL,0),(260,-5925460769789917447,NULL,1),(25,698859341222526663,NULL,0),(262,-5614426125890996189,NULL,1),(189,698859341220595838,NULL,0),(264,-7334106230978667395,NULL,1),(13,698859341222723713,NULL,0),(266,-6094770003454798997,NULL,1),(70,698859341219716088,NULL,0),(268,-1578049133946586512,NULL,1),(145,698859341222851063,NULL,0),(270,-2379628594821244242,NULL,1),(33,698859341223359913,NULL,0),(272,-4258720252080676365,NULL,1),(70,698859341219716088,NULL,0),(274,-7736361726928544132,NULL,1),(88,698859341222802663,NULL,0),(276,-2225208296058731768,NULL,1),(194,698859341221948988,NULL,0),(278,-4735125674155462996,NULL,1),(7,698859341222886288,NULL,0),(280,-5059204769057854577,NULL,1),(111,698859341221473588,NULL,0),(282,-6259100129307506215,NULL,1),(130,698859341220820313,NULL,0),(284,-4146414389143504532,NULL,1),(138,698859341222955963,NULL,0),(286,-6970567395870422718,NULL,1),(48,698859341222363113,NULL,0),(288,-4856299162764889434,NULL,1),(7,698859341222886288,NULL,0),(290,-6653069338928855243,NULL,1),(102,698859341219241263,NULL,0),(292,-2094537128741146752,NULL,1),(158,698859341220137863,NULL,0),(294,-6589601052882292207,NULL,1),(39,698859341219391513,NULL,0),(296,-5215836138737528857,NULL,1),(183,698859341222957463,NULL,0),(298,-6781250997083033308,NULL,1),(177,-7755910647778324744,NULL,0),(300,-4270011893587942190,NULL,1),(148,698859341222410438,NULL,0),(302,-6483931956649662166,NULL,1),(34,698859341220907388,NULL,0),(304,-3564536899588337408,NULL,1),(68,698859341222606313,NULL,0),(306,-6239158662503699617,NULL,1),(190,698859341222157088,NULL,0),(308,-1239526419881291252,NULL,1),(68,698859341222606313,NULL,0),(310,-5027749947253621510,NULL,1),(5,698859341220645388,NULL,0),(312,-5700680017735346203,NULL,1),(190,698859341222157088,NULL,0),(314,-1987897245635708254,NULL,1),(68,698859341222606313,NULL,0),(316,-4660845121880719753,NULL,1),(56,698859341222179288,NULL,0),(318,-4229313196145160992,NULL,1),(115,698859341223254163,NULL,0),(320,-1439337466665643491,NULL,1),(171,698859341222211463,NULL,0),(322,-5843718259541445219,NULL,1),(120,698859341221767488,NULL,0),(324,-6089705457168741494,NULL,1),(191,698859341223227988,NULL,0),(326,-1345036741935521758,NULL,1),(157,719975359453870400,NULL,0),(328,-5897494574753729373,NULL,1),(68,698859341222606313,NULL,0),(330,-7051218265274802232,NULL,1),(14,698859341220468238,NULL,0),(332,-5141945250090136360,NULL,1),(74,-3450319880119879358,NULL,0),(334,-6147986678883931598,NULL,1),(30,698859341220265538,NULL,0),(336,-4837171018038088877,NULL,1),(7,698859341222886288,NULL,0),(338,-5798903201652986785,NULL,1),(59,698859341219561888,NULL,0),(340,-4363463386854952750,NULL,1),(175,698859341220782363,NULL,0),(342,-3275003324868719040,NULL,1),(49,698859341221540338,NULL,0),(344,-1358237748170150342,NULL,1),(61,698859341222567913,NULL,0),(346,-5673421137088113974,NULL,1),(127,698859341222875238,NULL,0),(348,-2676768232071993055,NULL,1),(18,698859341221523988,NULL,0),(350,-4015025785573577473,NULL,1),(111,698859341221473588,NULL,0),(352,-7742444925230973755,NULL,1),(102,698859341219241263,NULL,0),(354,-6611240795988418896,NULL,1),(183,698859341222957463,NULL,0),(356,-1944789698909158140,NULL,1),(138,698859341222955963,NULL,0),(358,-7394215012922002788,NULL,1),(23,698859341219378038,NULL,0),(360,-2005598834345532361,NULL,1),(38,698859341223094838,NULL,0),(362,-4472654172655705969,NULL,1),(50,698859341220840163,NULL,0),(364,-3117460520763397464,NULL,1),(190,698859341222157088,NULL,0),(366,-2906027131802498579,NULL,1),(55,698859341221383888,NULL,0),(368,-7360607165871449443,NULL,1),(32,698859341219416788,NULL,0),(370,-2246418784641495803,NULL,1),(58,698859341219932588,NULL,0),(372,-3702599992770280016,NULL,1),(81,698859341220148913,NULL,0),(374,-5607459577316026694,NULL,1),(174,698859341221087663,NULL,0),(376,-3081336288759770229,NULL,1),(129,698859341219774263,NULL,0),(378,-4397828417355745337,NULL,1),(157,719975359453870400,NULL,0),(380,-3732992851543291381,NULL,1),(50,698859341220840163,NULL,0),(382,-5225860284051087678,NULL,1),(179,698859341221218838,NULL,0),(384,-5302076507461856008,NULL,1),(165,698859341222490013,NULL,0),(386,-4960396468119259571,NULL,1),(114,698859341221224988,NULL,0),(388,-1606432930501788443,NULL,1),(134,698859341223284513,NULL,0),(390,-7408853356192920243,NULL,1),(12,698859341222541713,NULL,0),(392,-7473707102485388804,NULL,1),(98,698859341221373788,NULL,0),(394,-7807525222869221943,NULL,1),(6,698859341219273513,NULL,0),(396,-6862607513320659873,NULL,1),(26,698859341220977763,NULL,0),(398,-5849472380298657561,NULL,1),(39,698859341219391513,NULL,0),(400,-7102641966071135650,NULL,1),(119,-3092833030787230894,NULL,0); 3、To concurrently execute new and unique key conflict update statements, please update the mysql account password in the script and run #!/bin/bash column_v=`mysql -udbmonitor_01 -pxxx -h127.0.0.1 -Ne"use test_feng;select concat(id,',',fingerprint,',',tag) from tmp_id "` for val in $column_v do { OLD_IFS="$IFS" IFS="," arr=($val) IFS="$OLD_IFS" id=${arr[0]} fingerprint=${arr[1]} tag=${arr[2]} if [ ${tag} == 1 ];then mysql -udbmonitor_01 -pxxx -h127.0.0.1 -Ne "use test_feng;insert into question set id = $id, content = '
', fingerprint = $fingerprint;" else mysql -udbmonitor_01 -pxxx -h127.0.0.1 -e "use test_feng;insert into question set content = '
', answer = 'See answer above', fingerprint = $fingerprint on duplicate key update content = '
', answer = 'See answer above+$fingerprint+$RANDOM';" fi }& done 4、Check whether the data is abnormal. If the data can be found through the following statement, it means that the updated data of the unique key conflict is abnormal and has been updated to the new id select * from question where id>200 and answer is not null;