Updating data

- To change the data in a table, use the update command.…Let's start by choosing the test database,…and I'm just gonna take a look at the…customer table with the select statement.…Select, asterisk, from, and customer.…When I press go, I get the table with five rows.…You notice that the row with the ID number five…has no data in address and zip.…We're gonna go ahead and fix that,…put some data in that row.…

I'm gonna copy and paste, so command + C to copy,…and command + V to paste.…Paste this statement into SID,…and this is an update statement,…and it specifies the table,…so update and then the table name.…And then, set and a list of assignments.…So you assign a literal string,…in this case, to the address column, and…a literal string to the zip column.…Then there's a where clause to indicate…which rows are going to be updated,…and this is where ID equals five,…so that's this row here with Jimi Hendrix.…

We're going to set the address column…to this string and the zip column to that string.…We have select after the update,…