草庐IT

telemarketer

全部标签

php - 错误更新限制mysql

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