在mysql语句分页中是识别不了运算符的 如:
select * from teble limit ((2-1)*5)
要把5改成:
select * from teble limit '((2-1)*5,'','',5,'
或者: set@(变量名)concat('select * from teble limit '((2-1)*5,'','',5,'');PREPARE per From @变量名;EXECUTE per;
如有错误请各位多多指点!!!
在mysql语句分页中是识别不了运算符的 如:
select * from teble limit ((2-1)*5)
要把5改成:
select * from teble limit '((2-1)*5,'','',5,'
或者: set@(变量名)concat('select * from teble limit '((2-1)*5,'','',5,'');PREPARE per From @变量名;EXECUTE per;
如有错误请各位多多指点!!!