Difference between revisions of "Update Queries"
| Line 5: | Line 5: | ||
| "UPDATE table SET column1=value1 WHERE column2=value2;" || Changes values in column1 to value1, where column2 equals value2 | | "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 values | + | | "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. | | "UPDATE table SET column1=value1, column2=value2;" || Changes column1 to value1 and column2 to value2. | ||
|} | |} | ||
Revision as of 14:50, 21 December 2016
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. |
