56,675
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
CREATE PROCEDURE proc1( table_name varchar(50))
begin
set @sql=concat('select * from `',table_name,'`');
PREPARE stmt FROM @sql;
EXECUTE stmt ;
DEALLOCATE PREPARE stmt;
end
$$
DELIMITER ;
call proc1('table1');