MySQL存储过程，表名作变量实例

1、首先创建存储过程

delimiter $$
DROP procedure IF EXISTS getDataByDbName $$ 
CREATE procedure getDataByDbName(in dbName VARCHAR(20))
BEGIN
SET @STMT =CONCAT("SELECT * from ",dbName,";"); 
PREPARE STMT FROM @STMT; 
EXECUTE STMT; 
end$$
delimiter;

2、然后给变量赋值

SET @name='person_tb'

3、最后执行SQL

CALL getDataByDbName(@name)

4、执行结果：