发一篇Mysql分页查询通用存储历程

列举选择MySQL的理由的最困难的地方在于，如何对这些理由进行排序。MySQL学习教程这就如同我们经常争论的故事：先有鸡还是先有蛋?前段工夫没有给出SQLServer转到MySQL的通用存储历程，本着共享的精力，为人人贡献这段Mysql分页查询通用存储历程，假定所用数据库为guestbook：
useguestbook;
delimiter$$
dropPRocedureifexistsprc_page_result$$
createprocedureprc_page_result(
incurrpageint,
incolumnsvarchar(500),
intablenamevarchar(500),
insConditionvarchar(500),
inorder_fieldvarchar(100),
inasc_fieldint,
inprimary_fieldvarchar(100),
inpagesizeint
)
begin
declaresTempvarchar(1000);
declaresSqlvarchar(4000);
declaresOrdervarchar(1000);

ifasc_field=1then
setsOrder=concat(orderby,order_field,desc);
setsTemp=<(selectmin;
else
setsOrder=concat(orderby,order_field,asc);
setsTemp=>(selectmax;
endif;

ifcurrpage=1then
ifsConditionthen
setsSql=concat(select,columns,from,tablename,where);
setsSql=concat(sSql,sCondition,sOrder,limit?);
else
setsSql=concat(select,columns,from,tablename,sOrder,limit?);
endif;
else
ifsConditionthen
setsSql=concat(select,columns,from,tablename);
setsSql=concat(sSql,where,sCondition,and,primary_field,sTemp);
setsSql=concat(sSql,(,primary_field,),from(select);
setsSql=concat(sSql,,primary_field,from,tablename,sOrder);
setsSql=concat(sSql,limit,(currpage-1)*pagesize,)astabtemp),sOrder);
setsSql=concat(sSql,limit?);
else
setsSql=concat(select,columns,from,tablename);
setsSql=concat(sSql,where,primary_field,sTemp);
setsSql=concat(sSql,(,primary_field,),from(select);
setsSql=concat(sSql,,primary_field,from,tablename,sOrder);
setsSql=concat(sSql,limit,(currpage-1)*pagesize,)astabtemp),sOrder);
setsSql=concat(sSql,limit?);
endif;
endif;
set@ipageSize=pagesize;
set@sQuery=sSql;
preparestmtfrom@sQuery;
executestmtusing@iPageSize;
end;
$$
delimiter;
能够存储为数据库剧本，然后用命令导进：
mysql-uroot-p<pageResult.sql;
挪用：callprc_page_result(1,"*","Tablename","","columnname",1,"PKID",25);
http://blog.csdn.net/fcrpg2005/archive/2007/03/07/1522713.aspx
关于这个理由我把它放在最后一位。在很多业界专家中有一个相当一致的观点：MySQL不能很好的扩展。关于这点可能有很大的分歧，争论的焦点主要集中于水平可扩展性和垂直可扩展性上。MySQL则更倾向于垂直可扩展性。