Views to Reduce Query Complexity -- 视图减少复杂查询
FROM (
SELECT * FROM people JOIN cart
ON (cart.people_id=people.id) WHERE firstname='john'
) a SELECT a.lastname WHERE a.id=3;
CREATE VIEW shorter_join AS
SELECT * FROM people JOIN cart
ON (cart.people_id=people.id) WHERE firstname='john';
SELECT lastname FROM shorter_join WHERE id=3;
View Odds and Ends
CREATE VIEW IF NOT EXISTS shipments(time, part
COMMENT 'Time and parts for shipments.'
TBLPROPERTIES ('creator' = 'me')
AS SELECT ...;
ALTER VIEW shipments SET TBLPROPERTIES ('created_at' = 'some_timestamp');