mysql + 更新前 n [英] mysql + update top n

问题描述

我有一个这样的查询:

update  table
set     status = 1
where   status = 2;     

但我只想对前 400 名执行此操作.我尝试添加一个限制 0, 400"(就像我在查询中那样)，但这没有用.我做了一些搜索，mysql似乎不像sql server那样支持TOP(n)命令.

but I'd only like to do this to the top 400. I tried adding a 'limit 0, 400' (like I would in a query) but that didn't work. I did some searching and mysql doesn't seem to support the TOP(n) command as sql server does.

知道我该怎么做吗?

为了将来参考，我使用以下样式进行选择，效果很好:

edit: for future reference, I was using the following style for selects, which worked fine:

select  * 
from    table
where   ... limit 0, 400;

但在更新中，无论出于何种原因，它都不能与0"一起使用.我会考虑这种不一致和模棱两可的行为，但是好吧.

but in the update it wouldn't work with the "0, " for whatever reason. I would consider this inconsistent and ambiguous behaviour, but oh well.

推荐答案

UPDATE  table
SET     status = 1
WHERE   status = 2
ORDER BY id
LIMIT 400

签入MySQL 5.2.0-falcon-alpha-community-nt-log，确认工作正常.

在您的情况下，它是 0 in LIMIT 0, 400 不起作用.

In your case it's 0 in LIMIT 0, 400 that does not work.

您不能在 UPDATE 的 LIMIT 中使用下限.

You cannot use the lower bound in UPDATE's LIMIT.

这篇关于mysql + 更新前 n的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！