Learn SQL Database Programming

Using the UPDATE statement with a WHERE clause

Let's say you made a mistake when you inserted a record for the college information earlier in this chapter. You can update this information with the UPDATE clause. To update data in a table in MySQL, use the following syntax:

UPDATE lahmansbaseballdb.collegeplayingSET`playerID` = <{playerID: }>,`schoolID` = <{schoolID: }>,`yearID` = <{yearID: }>WHERE ;

You can get this syntax by taking the following steps:

• Right-click on Tables in MySQL Workbench.
• Choose Send to SQL Editor.
• Choose Update Statement.

This places the UPDATE syntax for that table into a SQL query window.

You can execute this UPDATE query to update the record:

USE lahmansbaseballdb;UPDATE collegeplayingSET schoolID = 'sandiego', ...