1、统计一下插入的数据总数
SELECT COUNT(giftCertificateId) AS number FROM gift_certificate WHERE giftCertificateNo LIKE ‘boc%‘;
SELECT giftCertificateId, COUNT(gc.`giftCertificateId`) AS 总共 FROM gift_certificate gc WHERE giftCertificateNo LIKE ‘%boc%‘;
原文：http://www.cnblogs.com/bluewelkin/p/4036884.html