mysql-test/suite/ndbcluster/truncate.result
raw| 1 | CREATE TABLE t1 ( |
| 2 | a int PRIMARY KEY, |
| 3 | b varchar(255) |
| 4 | ) ENGINE = NDB; |
| 5 | INSERT INTO t1 (a, b) VALUES |
| 6 | (1, "Row 1"), |
| 7 | (11, "Row 2"), |
| 8 | (12, "The third row"), |
| 9 | (37, "And of course number 37"); |
| 10 | SELECT COUNT(*) FROM t1; |
| 11 | COUNT(*) |
| 12 | 4 |
| 13 | TRUNCATE TABLE t1; |
| 14 | SELECT COUNT(*) FROM t1; |
| 15 | COUNT(*) |
| 16 | 0 |
| 17 | DROP TABLE t1; |