Update Queries

For updating values already entered into a database. Can edit multiple rows at once. Not using the WHERE clause will cause every entry to be edited.

"UPDATE table SET column1=value1 WHERE column2=value2;"	Changes values in column1 to value1, where column2 equals value2
"UPDATE table SET column1=value1;"	Sets all column1 values, on every row, to value1 (regardless of their current value).
"UPDATE table SET column1=value1, column2=value2;"	Changes column1 to value1, and column2 to value2.