(mysql.info.gz) ANSI diff Views

Info Catalog

(mysql.info.gz) ANSI diff Foreign Keys

(mysql.info.gz) Differences from ANSI

(mysql.info.gz) ANSI diff comments

 
 1.5.5.6 Views
 .............
 
 Views (including updatable views) are implemented in the 5.0 version of
 MySQL Server.  Views are available in binary releases from 5.0.1 and up.
  `CREATE VIEW' CREATE VIEW.
 
 Views are useful for allowing users to access a set of relations
 (tables) as if it were a single table, and limiting their access to
 just that.  Views can also be used to restrict access to rows (a subset
 of a particular table).  For access control to columns, you can also
 use the sophisticated privilege system in MySQL Server.  
 Privilege system.
 
 In designing an implementation of views, our ambitious goal, as much as
 is possible within the confines of SQL, has been full compliance with
 "Codd's Rule #6" for relational database systems: "All views that are
 theoretically updatable, should in practice also be updatable."
 

Info Catalog

(mysql.info.gz) ANSI diff Foreign Keys

(mysql.info.gz) Differences from ANSI

(mysql.info.gz) ANSI diff comments