Learn SQL Database Programming

Updating table data from another existing table

If you need to update values from an existing table, you can use the following query:

USE lahmansbaseballdb;UPDATE managerscopy mcINNER JOIN managers m ON m.playerID = mc.playerID AND mc.teamID = m.teamID AND mc.yearID = m.yearIDSET mc.lgID = m.lgID

The previous query sets the values back to their original values in the managerscopy table, as in the following screenshot:

You can see, in the previous screenshot, that '--' has been replaced in the managerscopy with the original values from the existing managers table.

So far, you've learned how to gather information about your tables in order ...