如何在mysql中使用update query设置一个表的多列?
发布于 2010-09-08 20:00:15
只需添加参数,以逗号分隔:
UPDATE tablename SET column1 = "value1", column2 = "value2" ....
发布于 2010-09-08 19:59:54
UPDATE some_table
SET this_column=x, that_column=y
WHERE something LIKE 'them'
发布于 2022-02-07 07:44:30
让我们举一个例子,其中您有一个people
表,并且您想要更新age
和id
为5的person的name
列。查询将如下所示:
UPDATE people SET age = 34, name = "John" WHERE id = 5
https://stackoverflow.com/questions/3667439
复制相似问题