mySQL子查询限制 [英] mySQL subquery limit

问题描述

这可能很简单...如何通过此查询实现我想要的东西:

This is probably an easy one... how can I achieve what i want with this query:

delete from posts where id not in
(SELECT id FROM posts order by timestamp desc limit 0, 15)

因此，简而言之，我想删除不是最新的15篇文章中的每篇.

so, to put it in a nutshell, I want to delete every post that isn't on the latest 15.

当我尝试查询时，我会得到

When I try that query, I get that

MySQL尚不支持'LIMIT& IN/ALL/ANY/SOME子查询

MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery

编辑

mySQL Server version: 5.5.8
mySQL Client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $

错误:#1235-此版本的MySQL尚不支持'LIMIT& IN/ALL/ANY/SOME子查询"

Error: #1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

推荐答案

尝试一下:

DELETE 
FROM posts 
WHERE id not in (
      SELECT * FROM (
            SELECT id 
            FROM posts 
            ORDER BY timestamp desc limit 0, 15
      ) 
      as t);

这篇关于mySQL子查询限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！