Update Queries

From TRCCompSci - AQA Computer Science
Revision as of 14:49, 21 December 2016 by 000025845 (talk | contribs)
Jump to: navigation, search
"UPDATE table SET column1=value1 WHERE column2=value2;" Example
"UPDATE table SET column1=value1;" Example
"UPDATE table SET column1=value1, column2=value2;" Example

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.


Editing 'table'

--- Changes values in column1 to value1, where column2 equals value2.
--- Sets all values in the table, in column1, to value1 (regardless of their current value).
--- Changes column1 to value1 and column2 to value2.