Question

假设我有一个名为table_NAME的表，如下所示：

id  | name  | changeme
------------------------
1   | One   | 1
2   | Two   | 0
3   | Three | 1
4   | Four  | 0
5   | Five  | 0

是否有SQL语句可以在上面运行以将changeme的每个条目更改为0？

Answer 1

你是说？

UPDATE TABLE_NAME SET changeme = 0

Answer 2

update TABLE_NAME set changeme = 0 where changeme = 1

Answer 3

update TABLE_NAME SET changeme="0" WHERE id IN (1,3,4)

如果要更新ID特定的数据，如1,3和4

Answer 4

这适用于单桌

UPDATE table_name
SET field_name = replace(same_field_name,  unwanted_text ,  wanted_text )