前段时间没有给出SQLServer转到MySQL的通用存储过程,本着共享的精神,为大家奉献这段Mysql分页查询通用存储过程,假设所用数据库为guestbook:
use guestbook; delimiter $ drop PRocedure if exists prc_page_result $ create procedure prc_page_result ( in currpage int, in columns varchar(500), in tablename varchar(500), in sCondition varchar(500), in order_field varchar(100), in asc_field int, in primary_field varchar(100), in pagesize int ) begin declare sTemp varchar(1000); declare sSql varchar(4000); declare sOrder varchar(1000); if asc_field = 1 then set sOrder = concat('' order by '', order_field, '' desc ''); set sTemp = ''<(select min''; else set sOrder = concat('' order by '', order_field, '' asc ''); set sTemp = ''>(select max''; end if; if currpage = 1 then if sCondition <> '''' then set sSql = concat(''select '', columns, '' from '', tablename, '' where ''); set sSql = concat(sSql, sCondition, sOrder, '' limit ?''); else set sSql = concat(''select '', columns, '' from '', tablename, sOrder, '' limit ?''); end if; else if sCondition <> '''' then &n |