1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
SELECT COUNT(*) > 0 FROM performance_schema.setup_consumers
WHERE ENABLED = "NO";
COUNT(*) > 0
0
SELECT COUNT(*) > 0 FROM performance_schema.setup_instruments
WHERE NAME LIKE "%/fti/%" AND (ENABLED = 'NO' OR TIMED = "NO");
COUNT(*) > 0
0
CREATE TABLE t(a INT AUTO_INCREMENT PRIMARY KEY, b INT) ENGINE=TokuDB;
INSERT INTO t (b) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
INSERT INTO t (b) SELECT b FROM t;
UPDATE t SET b = 11 WHERE b = 10;
DELETE FROM t WHERE b = 1;
ALTER TABLE t ADD COLUMN c CHAR(10) default NULL;
TRUNCATE TABLE t;
RENAME TABLE t TO t1;
RENAME TABLE t1 TO t;
SELECT COUNT(*) > 0 FROM t;
COUNT(*) > 0
0
DROP TABLE t;
|
