查询的时候根据paixu字段升序就可以了: SELECT * FROM `table` WHERE 1=1 ORDER BY `paixu` ASC LIMIT 10;
上面考虑不够仔细,不知道你的paixu字段的默认值是怎么样的,为了建立组合索引,建议定义为INT UNSIGNED NOT NULL DEFAULT 999999999999,然后建立组合索引(paixu,id),查询时: SELECT * FROM `table` WHERE 1=1 ORDER BY `paixu` ASC,`id` DESC LIMIT 10;
SELECT * FROM `table` WHERE 1=1 ORDER BY `paixu` ASC LIMIT 10;
SELECT * FROM `table` WHERE 1=1 ORDER BY `paixu` ASC,`id` DESC LIMIT 10;
select * from table order by paixu
搞定.
改变顺序的话,输入指定序号后,应当更新后续的排序序号。
UPDATE `table` SET `paixu` = `paixu` + 1 WHERE `id` = 1(不等于自己ID)