MySQL paginazione senza query doppie?

To use MySQL pagination, let's first see how to use the CREATE command and create a table with it.

mysql> CREATE table RowCountDemo
　　　-> (
　　　-> ID int,
　　　-> Name varchar(100)
　　　-> );

The records are inserted with the help of the INSERT command.

mysql> INSERT into RowCountDemo values(1, 'Larry');
mysql> INSERT into RowCountDemo values(2, 'John');
mysql> INSERT into RowCountDemo values(3, 'Bela');
mysql>INSERT into RowCountDemo values(4,'Jack');
mysql>INSERT into RowCountDemo values(5,'Eric');
mysql>INSERT into RowCountDemo values(6,'Rami');
mysql>INSERT into RowCountDemo values(7,'Sam');
mysql>INSERT into RowCountDemo values(8,'Maike');
mysql>INSERT into RowCountDemo values(9,'Rocio');
mysql>INSERT into RowCountDemo values(10,'Gavin');

Visualizza tutti i record con la sentenza SELECT.

mysql>SELECT* from RowCountDemo;

Ecco l'output.

+------+-------+
| ID     | Name     |
+------+-------+
|        1 | Larry     |
|        2 | John     |
|        3 | Bela     |
|        4 | Jack     |
|        5 | Eric     |
|        6 | Rami     |
|        7 | Sam     |
|        8 | Maike |
|        9 | Rocio |
|     10 | Gavin |
+------+-------+
10 righe nel set (0.00 sec)

Ora vediamo la grammatica di paginazione senza query ripetute.

SELECT column_name From `yourTableName` WHERE someCondition LIMIT value1, value2;

Ora applichiamo la grammatica sopra.

mysql> SELECT ID,Name FROM `RowCountDemo` WHERE ID > 0 LIMIT 0, 11;

Ecco l'output della query sopra.

+------+-------+
| ID     | Name     |
+------+-------+
|        1 | Larry     |
|        2 | John     |
|        3 | Bela     |
|        4 | Jack     |
|        5 | Eric     |
|        6 | Rami     |
|        7 | Sam     |
|        8 | Maike |
|        9 | Rocio |
|     10 | Gavin |
+------+-------+
10 righe nel set (0.00 sec)