| 1 |
SET autocommit = 0; |
| 2 |
START TRANSACTION; |
| 3 |
*** Running query: SELECT COUNT(*) FROM t1 |
| 4 |
SELECT COUNT(*) FROM t1 WHERE `pk` MOD 5 = 0 AND `pk` BETWEEN 1 AND 1000; |
| 5 |
COUNT(*) |
| 6 |
200 |
| 7 |
SELECT COUNT(*) FROM t1 WHERE `pk` MOD 5 = 0 AND `pk` BETWEEN 1 AND 1000; |
| 8 |
COUNT(*) |
| 9 |
200 |
| 10 |
COMMIT; |