SQL UPDATE examples

UPDATE Gene SET name='OB1' WHERE number=11;

UPDATE Gene SET chromosome=NULL, first=NULL, last=NULL WHERE number=12;

UPDATE Protein SET seqlength=LENGTH(seq);