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=?