1.最基本的传出
select count(*) from Agent into pageNo;
将Agent的总数传给pageNo
2.构造动态sql语句
如果需要传入表名或者列名时,就需要使用动态的sql语句来执行了,如下:
set @sql=concat('select count(*) into @pageNo from Agent where Agent.isDeleted=0 and ', _fieldName,'="',_fieldValue,'"');
prepare countSql from @sql;
execute countSql;
DEALLOCATE PREPARE countSql;
set pageNo=@pageNo;
将Agent查询出的结果条数赋给pageNo