mysql 查询表中最后一行数据库

SELECT * FROM your_table_name
ORDER BY your_timestamp_column DESC
LIMIT 1;

SELECT * FROM your_table_name
WHERE your_timestamp_column = (
    SELECT MAX(your_timestamp_column) FROM your_table_name
);

DELIMITER //

CREATE PROCEDURE getLastRow()
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_name ORDER BY timestamp_column DESC;
    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 getLastRow();