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)