一次更新一个表的某些行. [英] update the some rows of one table at once.

问题描述

如何一次更新表中的所有行，所有这些行都与相同的代码相同.

How can many rows of a table, all of which are identical to the same code at once updated.

推荐答案

取决于Where子句. br/>
例如，如果您使用的Where 子句中有五行具有相同的列值，则将更新所有这五行.

当然，这是否正确取决于您的业务需求和您要做什么.

Depends on the Where clause.

If, say, there are five rows that have the same column values in the Where clause you are using, all 5 will be updated.

Whether this is correct or not, of course, will depend on your business needs and what you are trying to do.

这篇关于一次更新一个表的某些行.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！