<P> An SQL UPDATE statement changes the data of one or more records in a table . Either all the rows can be updated, or a subset may be chosen using a condition . </P> <P> The UPDATE statement has the following form: </P> <Dl> <Dd> UPDATE table_name SET column_name = value (, column_name = value ...) (WHERE condition) </Dd> </Dl> <Dd> UPDATE table_name SET column_name = value (, column_name = value ...) (WHERE condition) </Dd>

How to change the values of a column in sql