获取按“行ID"排序的SELECT结果在MySQL中 [英] Get SELECT results ordered by "row id" in mySQL

问题描述

如果表没有自动递增的列/键，如何获得按行ID 排序的SELECT结果?

How can I get SELECT results ordered by row id if table does not have auto-increment column/key?

另外，如果我不能使用ORDER BY子句，因为没有自动增量行，那么我如何使用LIMIT来获取最后100个?

Additionally, how can I for example get last 100 of them, using LIMIT, if I cannot use ORDER BY clause, as no auto-increment row is present?

推荐答案

这个(见下文)有效，但是有点慢...

This one (see below) works, but it is kinda slow...

SET @last = 100;
SET @ofst = (SELECT COUNT(*) FROM table) - @last;
SET @stmt = CONCAT('SELECT * FROM table LIMIT ', @ofst, ', ', @last);
PREPARE stmt FROM @stmt;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

这篇关于获取按“行ID"排序的SELECT结果在MySQL中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！