Debian Codegraph @

mysql-test/suite/ndb/r/ndb_truncate.result

raw
1 DROP TABLE IF EXISTS t1, t2;
2 CREATE TABLE t1 (
3 a bigint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
4 b int unsigned not null,
5 c int unsigned
6 ) engine=ndbcluster;
7 select count(*) from t1;
8 count(*)
9 5000
10 select * from t1 order by a limit 2;
11 a b c
12 1 509 2500
13 2 510 7
14 truncate table t1;
15 select count(*) from t1;
16 count(*)
17 0
18 insert into t1 values(NULL,1,1),(NULL,2,2);
19 select * from t1 order by a;
20 a b c
21 1 1 1
22 2 2 2
23 drop table t1;