call getall(表名)

SQL code

delimiter //

 create procedure getall(table_name varchar(50),num int(5))
 begin
 select * from table_name limit 0,num;
 end//

call getall('users',10)//

为什么提示 table_name不存在啊， 我明明定义的 table_name是个变量的。

set @asql=concat('select * from ',table_name,' limit 0,',num);
prepare stml from @asql;
execute stml;

delimiter //

create procedure getall(table_name varchar(50),num int(5))
begin
set @sql=concat('select * from ',table_name,' limit 0,',num);
PREPARE stmt1 from @sql;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1
end//

call getall('users',10)//