-- dev手机号与userid的对应关系与test手机号与userid的对应关系不一致,希望查询出不一致的数据。
-- dev库执行
show variables like 'group_concat_max_len';
SET SESSION group_concat_max_len = 102400000;
SELECT
GROUP_CONCAT( "'", user_id, "_", mobile, "'" ) AS usercode
FROM
dev.user;
-- 查询结果
'1_11000000000','2_11000000002'
-- test库执行
SELECT * FROM test.user WHERE concat( user_id, "_", mobile ) not in ('1_11000000000','2_11000000002');