Debian Codegraph @

mysql-test/suite/ndb_ddl/show_name_of_special_table.inc

raw
1 #
2 # Show name of tables whose name starts with "t_special" in NDB
3 # and all the MySQL Servers
4 #
5
6 # Show name of table in NDB
7 --disable_query_log ONCE
8 SELECT CONCAT("'", fq_name, "'") as Name_in_NDB
9 FROM ndbinfo.dict_obj_info
10 WHERE type = 2 AND fq_name LIKE "%/def/t_special%";
11
12 # Show name of table and its engine in DD on all MySQL Servers
13 let $i = $NUM_MYSQLDS;
14 while($i)
15 {
16 --connection mysqld$i
17 --disable_query_log ONCE
18 eval SELECT CONCAT("'", TABLE_SCHEMA, ".", TABLE_NAME,
19 "' - ", ENGINE) AS Name_in_mysqld$i
20 FROM information_schema.tables
21 WHERE TABLE_NAME LIKE 't_special%';
22 dec $i;
23 }
24 connection default;