MySQL如何快速比较查询结果是否一致

原文参考：http://www.xaprb.com/blog/2009/03/25/mysql-command-line-tip-compare-result-sets/

利用mysql客户端的pager功能即可：

mysql> pager md5sum -
PAGER set to 'md5sum -'
mysql> select * from user;
b20bd3864962507e2e05cd8706440ffd  -
3 rows in set (0.00 sec)
mysql> select * from user;
b20bd3864962507e2e05cd8706440ffd  -
3 rows in set (0.00 sec)
mysql> select * from user;
b20bd3864962507e2e05cd8706440ffd  -
3 rows in set (0.00 sec)

from: http://imysql.cn/2009/03/25/mysql-faq-compare-result-sets.html