Debian Codegraph @

mysql-test/suite/ndbcluster/basic.result

raw
1 CREATE TABLE t1 (
2 a int PRIMARY KEY,
3 b varchar(255)
4 ) ENGINE = NDB;
5 INSERT INTO t1 VALUES (1, "MySQL Server with NDB");
6 INSERT INTO t1 (a, b) VALUES (11, "Barrier effect");
7 INSERT INTO t1 (a, b) VALUES
8 (12, "The third row"),
9 (37, "And of course number 37");
10 SELECT * FROM t1 WHERE a = 1;
11 a b
12 1 MySQL Server with NDB
13 UPDATE t1 SET b = CONCAT(b, " test") WHERE a = 1;
14 SELECT * FROM t1 WHERE a = 1;
15 a b
16 1 MySQL Server with NDB test
17 REPLACE t1 (a, b) VALUES (12, "Another layer");
18 SELECT * FROM t1 WHERE a = 12 ORDER BY a;
19 a b
20 12 Another layer
21 DELETE FROM t1 WHERE a = 11;
22 SELECT COUNT(*) FROM t1;
23 COUNT(*)
24 3
25 SELECT b FROM t1 WHERE b LIKE "MySQL%";
26 b
27 MySQL Server with NDB test
28 DELETE FROM t1 ORDER BY b DESC;
29 DROP TABLE t1;