我有一个查询,当我选择运行它时,我得到1014条记录。当我将其作为更新运行时,它更新的记录数通常少于5。例子Select * from Tablewhere firstname ='john'and lastname = 'smith'and email='john.smith@gmail.com'返回1014行update Tableset meaninglesscolumn = 1where firstname ='john'and lastname = 'smith'and email='john.smith@gmail.com'运行此查询后,此更新返回1012(或更低的数字,每次运行后都会不断下降,但运行+500次将很麻烦)Select * from Tablewhere firstname ='john'and lastname = 'smith'and email='john.smith@gmail.com'and meaninglesscolumn <> 1谢谢。更新抱歉,上面的“选择”返回1658条记录,而不是1014条记录。我用“和无意义的列 1”运行它,得到1015条记录(我要更新的记录数)。然后,我运行上面的“更新”和“选择”并得到1014,然后我再次运行“更新”并得到1012。如此全过程...Select * from Tablewhere firstname ='john'and lastname = 'smith'and email='john.smith@gmail.com'返回1658Select * from Tablewhere firstname ='john'and lastname = 'smith'and email='john.smith@gmail.com'and meaninglesscolumn <> 1返回1015update Tableset meaninglesscolumn = 1where firstname ='john'and lastname = 'smith'and email='john.smith@gmail.com'返回1行已更新。Select * from Tablewhere firstname ='john'and lastname = 'smith'and email='john.smith@gmail.com'and meaninglesscolumn <> 1返回1014 (adsbygoogle = window.adsbygoogle || []).push({}); 最佳答案 您为什么不只使用while循环来更新它们呢?选择while(结果=获取){ 更新} (adsbygoogle = window.adsbygoogle || []).push({});