Question

SQL 用update语句一次更新多个字段应该怎么写

Answer 1

UPDATE TABLE
SET COL1 = '你的数据'
,COL2 ='你的数据'
...
,COLN ='你的数据'
WHERE COLX = XXXX

Answer 2

update 表名

set 栏位1='' , 栏位2='',...
where ...

Answer 3

给你举个例子吧
UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing'
WHERE LastName = 'Wilson'

Answer 4

update table set column1 = 'a', column2='b', column3='c' where id = '';