删除ID最低的记录 [英] Deleting record with lowest ID

问题描述

当我在MySQL中键入此查询时:

When I type this query in MySQL :

DELETE FROM myTable WHERE ID = ( SELECT Min( ID ) FROM myTable )

我收到以下错误消息:

#1093 - You can't specify target table 'myTable' for update in FROM clause

出什么问题了?

什么是正确的等价物?

推荐答案

基本上，在MySQL中，您无法对在SELECT部分中使用的表进行更新.有关详细信息，您可以检查记录在以下内容中的此行为: http://dev .mysql.com/doc/refman/5.6/en/update.html

Basically in MySQL you can't do an update on a table which you use in the SELECT part. For detail you could check this behaviour which is documented at: http://dev.mysql.com/doc/refman/5.6/en/update.html

理论上，每个DELETE都是UPDATE，所以这就是为什么会出现此错误的原因.

In theory every DELETE is an UPDATE so that's why you get this error.

您可以简单地执行以下操作:

You could simply do following:

DELETE FROM myTable 
ORDER BY my_id
LIMIT 1;

这篇关于删除ID最低的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！