9.1.7 ViewsThis is NOT the latest copy of this book; click here for the latest version.
If you want to design particular snapshots of your database for users, where a very simple query can present a combination of data from several tables all at once, then views are for you. They work somewhat like stored procedures in that you pre-design a layout, then just load the view from then on. Also like stored procedures, your views are stored in the DBMS, so you can change them in one location and have all your code that calls them change also.
When views are used, users have access to views rather than tables - when a view is called, they might see fields A, B, and C from table 1, and fields D, E, and F from table 2 combined, but they would have no other access to table 1 or table 2.
MySQL does not support views in v4, and is not planned to support them until v5.1.
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
