mysql查询前10条评论

SELECT * FROM comments ORDER BY created_at DESC LIMIT 10;

SELECT * FROM comments ORDER BY created_at DESC LIMIT 10;

CREATE INDEX idx_created_at ON comments(created_at);

START TRANSACTION;
SELECT * FROM comments ORDER BY created_at DESC LIMIT 10;
COMMIT;

-- 创建示例表
CREATE TABLE comments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    content TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 插入示例数据
INSERT INTO comments (content) VALUES
('Great post!'),
('Thanks for sharing.'),
('I have a question.'),
('Very informative.'),
('Nice work!'),
('Looking forward to more.'),
('Awesome article!'),
('Can you elaborate more?'),
('I agree with you.'),
('Thanks for the update.'),
('Another great post.');

-- 查询前10条评论
SELECT * FROM comments ORDER BY created_at DESC LIMIT 10;