将employee 表中职工号为“19620426”的记录中“单位号”修改为“003”正确的SQL语句是________。
A.
update employee set 单位号="003" where 职工号 is "19620426"
B.
update employee 单位号 with "003" where 职工号= "19620426"
C.
update employee set 单位号="003" where 职工号="19620426"
D.
update employee where 职工号 is "19620426" set 单位号="003"