需求:将查询出的结果 跟json字符串进行对比,找出不一致的
DROP PROCEDURE IF EXISTS get_user_info;
CREATE PROCEDURE get_user_info(OUT user_info_result INT)
BEGIN
DECLARE s int DEFAULT 0;
DECLARE var1 VARCHAR ( 255 );
DECLARE var2 VARCHAR ( 255 );
DECLARE var3 longtext DEFAULT '{
"AL100712056": "郑州市"
}';
DECLARE youbiao CURSOR FOR SELECT order_number,car_city from tb_financial_july3 where id>0;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET s=1;
OPEN youbiao;
FETCH youbiao INTO var1,var2;
WHILE s <> 1 DO
IF json_extract(var3, concat('$.',var1)) <> var2 THEN
SELECT var1;
END IF;
FETCH youbiao INTO var1,var2;
END WHILE;
CLOSE youbiao;
END;
SET @total = 1;
SET @total1 = 1;
CALL get_user_info(@total);