来自这个问题:updatemultiplerowsusinglimitinmysql?我为MySQL查询编写了这段代码:UPDATEclientesSETtelemarketer=1WHEREtelemarketerIN(SELECTtelemarketerFROM(SELECTtelemarketerFROMclientesWHEREtelemarketer=0ORDERBYtelemarketerDESCLIMIT0,10)temporal);但是它返回了一个SELECTtelemarketerFROMclientes。环顾四周,我发现在这种情况下需要ORDERBY否则它会返回随机