mysql 存储过程动态传表名，删除表数据

最新推荐文章于 2024-10-23 17:40:07 发布

牧佑

最新推荐文章于 2024-10-23 17:40:07 发布

阅读量756

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/qq_34301871/article/details/80984486

本文介绍了一个MySQL存储过程的实现方式，该过程会根据是否存在特定字段动态调整查询语句。如果表中存在'data_src'字段，则仅选择'data_src'为'U8'的数据；若该字段不存在，则返回所有数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

drop procedure if exists mlook;
create procedure mlook(in tbl varchar(100))
begin
 IF NOT EXISTS (SELECT * FROM information_schema.columns 
	
	WHERE table_schema='mes' AND table_name = @name AND column_name = 'data_src') THEN 

SET @sqlcmd = concat('select * from ', tbl);
prepare stmt from @sqlcmd;
execute stmt;
deallocate prepare stmt;

ELSEIF EXISTS (SELECT * FROM information_schema.columns 
	
	WHERE table_schema='mes' AND table_name = @name AND column_name = 'data_src') THEN  

SET @sqlcmd = concat('select * from ', tbl,'WHERE data_src=U8');
prepare stmt from @sqlcmd;
execute stmt;
deallocate prepare stmt;

 END if;
end;


call mlook('mi_inventory');

希望能帮助到各位。