09. pt-fingerprint


vim pt-fingerprint.txt

select name, password from user where id=5;
select name, password from user where id=6;
select name, password from user where id=7;
select name, password from user where id=8;
select name, password from user where id=9;
select name, password from user where id=10;
select name, password from user where id=11;
select name, password from user where id=12;
select name, password from user where id=13;
select name, password from user where id=11;

pt-fingerprint --match-embedded-numbers pt-fingerprint.txt |sort|uniq

select name, password from user where id=?

pt-fingerprint --match-embedded-numbers --query 'select name, password from user where id=5'

select name, password from user where id=?

wechat: nick753159 qq: 417966852 email: nzq42@qq.com base: shanghai
原文地址:https://www.cnblogs.com/cyberbit/p/pt-fingerprint.html