SELECT * FROM city.u_device u where deviceType =1 limit 0,4;
查询结果:
24, 1, '格力', 'eeee', '04A3D3DEC8EFA99A21FB84A893D60FF7'
21, 1, '格力', 'TS2012', '04A3D3DEC8EFA99A21FB84A893D60FF7'
88, 1, '格力', 'TS202', '04A3D3DEC8EFA99A21FB84A893D60FF7'
31, 1, '格力', 'TS9999', '04A3D3DEC8EFA99A21FB84A893D60FF7'
SELECT * FROM city.u_device u where deviceType =1 limit 0,20;
查询结果:
21, 1, '格力', 'TS2012', '04A3D3DEC8EFA99A21FB84A893D60FF7'
22, 1, '海尔', 'TD212', '04A3D3DEC8EFA99A21FB84A893D60FF7'
23, 1, '海尔', 'rrrrr', '04A3D3DEC8EFA99A21FB84A893D60FF7'
24, 1, '格力', 'eeee', '04A3D3DEC8EFA99A21FB84A893D60FF7'
31, 1, '格力', 'TS9999', '04A3D3DEC8EFA99A21FB84A893D60FF7'
88, 1, '格力', 'TS202', '04A3D3DEC8EFA99A21FB84A893D60FF7'
我不是很理解,mysql是不是在每页大小小的时候,不是按照id进行排序,如果每页大小大的时候,是按照id排序的?