1.创建存储过程shishi5:
CREATE DEFINER=`root`@`localhost` PROCEDURE `shishi5`(
IN input_name varchar(20)
)
begin
declare table_name varchar(20) default '';
set table_name=input_name;
set @statements = concat('select * from ',table_name);
prepare stmt from @statements;
execute stmt;
deallocate prepare stmt;
end;
2.执行存储过程,users为表的名称:
call shishi5('users');