Updating Data in SQL

Not only do you need to add new records, but at some point you also need to change the records. To update records, you use the UPDATE statement. Specifying which records to change is the main difference between inserting new data and updating existing data. You specify which records to update with the WHERE clause, which allows you to specify that the only records to update are those where a certain condition is true. For example, say film club member Steve Gee has changed his address. His MemberId is 4, so you could tell the database to...

read more