MYSQL Stats Rankings

Example:

SET @ranking =0;select *, @ranking: [email protected]+1 as ' ranking ' from table ORDER by ' members ' DESC;

1. Assign the user variable @ranking first, and the user variable in MySQL begins with @ without prior declaration;

2. Then sort by a field and add the following code to the return field:

@ranking: [Email protected]+1

This results in a query that contains the ranking field, which represents the current rank.

Problems encountered:

1. Execute statement prompt syntax error, separate execution without error.

2. Data paging

SET @ranking = Current Page * Number of pages per page;

3. Ranking of a record

SET @ranking =0;select * FROM (SELECT *, @ranking: [e-mail protected]+1 as ' ranking ' from table ORDER by ' members ' DESC) as re Sult where result.id = 17;

The above are optimized;

MYSQL Stats Rankings