mysql - 这个 MYSQL DELETE 语句有什么问题？

Question

我想从表中删除大于某个 message_id 的记录。我的删除语句似乎不起作用。

http://sqlfiddle.com/#!2/4f8ee/1

提前致谢

Answer 1

DELETE c
FROM `chat_history3` c
inner join 
(
   select message_id from `chat_history3` 
   where clan_id=4 
   ORDER BY message_id DESC 
   limit 30, 30000
) x
on c.`message_id` < x.`message_id` 

SQLFiddle demo