add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
roleId roleFields
1 dataField1,dataField2,dataField3,dataField4
2 dataField1,dataField2
3 dataField1,dataField3,dataField4
upd clm whr
update myTable set dataField1=@dataField1 null
null dataField2=@dataField2 null
null dataField3=@dataField3 null
null dataField4=@dataField4 where roleId=1
update myTable set dataField1=@dataField1 null
null dataField2=@dataField2 where roleId=2
update myTable set dataField1=@dataField1 null
null dataField3=@dataField3 null
null dataField4=@dataField4 where roleId=3
sqlString
update myTable set dataField1=@dataField1
dataField2=@dataField2
dataField3=@dataField3
dataField4=@dataField4where roleId=1
update myTable set dataField1=@dataField1
dataField2=@dataField2where roleId=2
update myTable set dataField1=@dataField1
dataField3=@dataField3
dataField4=@dataField4where roleId=3