Question

我想在表格中选择第一行,顺序为time(发送),然后删除这一行文。我不想使用两个问题,因为另一个客户有可能在删除该行之前选择该行(这将是几个从不同网络一度连接的机器)。

我认为,我可以做这样的事情。

SELECT * FROM `mytable` ORDER BY `time` LIMIT 1;
    DELETE FROM `mytable` ORDER BY `time` LIMIT 1

......但我犯了一个错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ; DELETE * FROM pending ORDER BY time LIMIT 1 at line 1

这样做的最佳途径是什么? 感谢。

Answer 1

您的错误信息(不同于您的问题):

DELETE * FROM pending ORDER BY time LIMIT 1

看一看你yn的错误。删除<代码>*。这就是说,

DELETE FROM pending ORDER BY time LIMIT 1

工作罚款。

Answer 2

您必须设立一个临时表格,MySQL确实不请你从你使用的表格中删除,见本法典:

insert  tmpTable
        (id)
select  id
from    YourTable yt
order by time limit 1;

delete  
from    YourTable
where   ID in (select id from tmpTable);

Answer 3

你们可以像现在这样使用分座。

delete from table where id in ( select id from table order by time limit 1);

业绩是明智的,这一解决办法是多么好。你们也许必须做分析,看看你如何工作。

友情链接