如:create procedure proc_rizhi_log(in s Varchar(100))
begin
set @ss = s;
select * from t_operation_log_2 ss;
end
----------------------------------------------------+当我这样调用时:
call proc_rizhi_log('limit 0,20');他也把所有的记录都返回了,这是怎么会使啊,怎么解决呢?
begin
set @ss = s;
select * from t_operation_log_2 ss;
end
----------------------------------------------------+当我这样调用时:
call proc_rizhi_log('limit 0,20');他也把所有的记录都返回了,这是怎么会使啊,怎么解决呢?
create procedure proc_rizhi_log(in s integer)
beginselect * from t_operation_log_2 limit 0,s;
end这样不可?
begin
declare 1_sql varchar(4000);
set 1_sql=concat_ws(' ','select * from t_operation_log_2',s);
set @sql = 1_sql;
prepare s1 from @sql;
EXECUTE s1;
deallocate prepare s1;
end