下面sql语句正确的有()。
A.update into user set id = 'u001'
B.update user set id = 'u001' and username='jack'
C.update user set username='jack' where id = 1;
D.update into user set id = 'u001', username='jack';
正确答案是C