Is this SQL code update correctly while I update in one row?-CodePudding

UPDATE Vaccine SET VaccineNo = 'Sinovac Dose 1' WHERE VaccineNo = 'SIND01';

The question for this code:

CodePudding user response：

The syntax looks correct but I think you misunderstood the question. The question asks you to update the description and not the VaccineNo. Instead the query would look more something like UPDATE Vaccine SET Description = 'Sinovac Dose 1' WHERE VaccineNo = 'SIND01'; depending on what the description column name is.

CodePudding user response：

There's probably a description field in the table as per the question. Something like UPDATE Vaccine SET Description = 'Sinovac Dose 1' WHERE VaccineNo = 'SIND01'; but your code is syntactically correct