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;