SELECT 
    tid, 
    subject, 
    create_date, 
    FROM_UNIXTIME(create_date) AS readable_time 
FROM bbs_thread 
WHERE FROM_UNIXTIME(create_date, '%Y-%m') = '2025-08'
LIMIT 10;

DELETE FROM bbs_thread
WHERE FROM_UNIXTIME(create_date, '%Y-%m') = '2025-08';

DELETE p FROM bbs_post p
INNER JOIN bbs_thread t ON p.tid = t.tid
WHERE FROM_UNIXTIME(t.create_date, '%Y-%m') = '2025-08';

-- 1. 查删除前最后一个 tid
SELECT MAX(tid) FROM bbs_thread WHERE create_date < UNIX_TIMESTAMP('2025-08-01');

-- 假设结果是 150

-- 2. 设置下一个 tid 为 151
ALTER TABLE bbs_thread AUTO_INCREMENT = 151;