mysql查最后10行

SELECT * FROM your_table
ORDER BY id DESC
LIMIT 10;

SELECT * FROM your_table
WHERE id >= (
    SELECT id FROM your_table
    ORDER BY id DESC
    LIMIT 1, 1
)
ORDER BY id DESC
LIMIT 10;

DELIMITER //

CREATE PROCEDURE getLast10Rows()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE v_id INT;
    DECLARE v_data VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT id, data FROM your_table ORDER BY id DESC LIMIT 10;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO v_id, v_data;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SELECT v_id, v_data;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL getLast10Rows();