mysql max rows_获取MYSQL中的MaxRow计数/从单个调用的过程中获取FOUND_ROWS和数据表

为了同样我写了下面的程序，我已经返回 h2>

CREATE PROCEDURE usp_SearchEmp(IN _RowIndex int, IN _MaxRows int , IN _SortByCol varchar(40),IN _EmployeeID int)

DECLARE _getLastSequenceNumberSQL VARCHAR(4000);

set _getLastSequenceNumberSQL ='

SELECT SQL_CALC_FOUND_ROWS

@rownum:=@rownum+1 ROW,

E.EmployeeID,

E.EmployeeName

from

(SELECT @rownum:=0) r, Employee E ;

IF (_EmployeeID IS NOT NULL) THEN

set _getLastSequenceNumberSQL = concat(_getLastSequenceNumberSQL,' WHERE (E.EmployeeID=',_EmployeeID,')');

END IF;

IF (_SortByCol IS NOT NULL) AND (_SortByCol != "") THEN

set @SortCol = concat(' ORDER BY ', _SortByCol) ;

ELSE

set @SortCol = 'ORDER BY EmployeeName';

END IF;

set _getLastSequenceNumberSQL = concat(_ge