是的。它有两个查询，首先生成SQL，然后执行它。
设置示例：

MariaDB [(none)]> create database rr;
Query OK, 1 row affected (0.000 sec)

MariaDB [(none)]> create database ss;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> create table ss.wp_options(option_name varchar(30), option_value varchar(30));
Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> create table rr.rr_options(option_name varchar(30), option_value varchar(30));
Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> insert into ss.wp_options values ('admin_email', 'me@ss');
Query OK, 1 row affected (0.003 sec)

MariaDB [(none)]> insert into rr.rr_options values ('admin_email', 'me@rr');
Query OK, 1 row affected (0.002 sec)

然后使用information_schema.TABLES生成查询，使用UNION ALL将它们连接起来：

SELECT group_concat(
  concat('select "', TABLE_SCHEMA, '" as db, option_value from ', TABLE_SCHEMA, '.', TABLE_NAME, ' WHERE option_name="admin_email"')
 SEPARATOR ' UNION ALL ') INTO @sql
FROM information_schema.TABLES
WHERE TABLE_NAME LIKE '%_options';

只是为了展示我们产生的结果：

MariaDB [(none)]> select @sql\G
*************************** 1. row ***************************
@sql: select "ss" as db, option_value from ss.wp_options WHERE option_name="admin_email"
  UNION ALL select "rr" as db, option_value from rr.rr_options WHERE option_name="admin_email"

Execute immediate运行一个查询，就像一个没有setup和run、shutdown步骤的预准备语句：

MariaDB [(none)]> execute immediate @sql;
+----+--------------+
| db | option_value |
+----+--------------+
| ss | me@ss        |
| rr | me@rr        |
+----+--------------+
2 rows in set (0.002 sec)