列 存储 mysql_如何执行存储在表列MySQL中的查询？

您可以使用游标来获取CT表上的每个REPORT_QUERY,并使用预准备语句执行该操作：

delimiter $$

drop procedure if exists run_queries$$

create procedure run_queries()

begin

declare s_query varchar(255);

declare done bool default false;

declare c_queries cursor for

select REPORT_QUERY from CT;

declare continue handler for not found set done = true;

open c_queries;

read_loop: loop

fetch c_queries into s_query;

if done then

leave read_loop;

end if;

-- run the query

set @sql = s_query;

prepare stmt from @sql;

execute stmt;

deallocate prepare stmt;

end loop;

end$$

创建过程后,您可以调用如下：

调用run_queries();

而已.