Debian Codegraph @

mysql-test/suite/ndb_big/test_250_mysqld.result

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