mysql看表最后一行内容

SELECT * FROM table_name ORDER BY id DESC LIMIT 1;

SELECT * FROM table_name WHERE id = (SELECT MAX(id) FROM table_name);

SET @row_number = 0;
SELECT * FROM (
    SELECT @row_number := @row_number + 1 AS row_number, t.*
    FROM table_name t
    ORDER BY id DESC
) AS subquery
WHERE row_number = 1;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');
INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com');
INSERT INTO users (name, email) VALUES ('Charlie', 'charlie@example.com');

SELECT * FROM users ORDER BY id DESC LIMIT 1;