31
Updating Views
How can I insert a tuple into a table that doesn’t
exist?
Employee(ssn, name, department, project, salary)
CREATE VIEW Developers AS
SELECT name, project
FROM Employee
WHERE department = “Development”
INSERT INTO Developers
VALUES(“Joe”, “Optimizer”)
VALUES(“Joe”, “Optimizer”)
INSERT INTO Employee
VALUES(NULL, “Joe”, “Development”, “Optimizer”, NULL)
VALUES(NULL, “Joe”, “Development”, “Optimizer”, NULL)
If we make the
following insertion:
It becomes: