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

2024-11-15 14:52:40
推荐回答(4个)
回答1:

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

回答2:

update 表名

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

回答3:

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

回答4:

update 表 set 字段1=“”,字段2="XXX",字段3=AAA;