Learn SQL Database Programming

Updating data using a view that has multiple tables

You can update data via a view that has multiple tables. First, you need to set up a copy of an existing table so you don't update the data in the original table. You can do that with the following query:

USE lahmansbaseballdb;DROP TABLE IF EXISTS collegeplaying_copy; CREATE TABLE collegeplaying_copySELECT * FROM collegeplaying;

Next, you can create a view with this new table in it with the following query:

USE lahmansbaseballdb;DROP VIEW IF EXISTS collegeplayingbyname; CREATE VIEW collegeplayingbyname AS SELECT namefirst, namelast, schoolid, yearid FROM collegeplaying_copy cINNER JOIN people p ON p.playerid = c.playerid; 

You can see what the view contains by executing the following query: ...