A few weeks before that, at the
MySQL Users Conference in Santa Clara, a presentation was titled "PHP 5 + MySQL
5 = A Perfect 10". Indeed, we were aware of what this anniversary meant in terms of
products' maturity.
The MySQL 5.0.x history spans quite a long time. Indeed, the 5.0.0 alpha version
became available in December 2003, and started the round of new features with basic
support for stored procedures. In the next version (5.0.1), views support was born.
Information_schema appeared in version 5.0.2. Later, version 5.0.3 was labeled
Beta and released in March 2005, while 5.0.13 was considered a release candidate in
September 2005. A production release, 5.0.15, was made available in October 2005.
You should worry and talk to your system administrator or ISP if they
want you to use a pre-5.0.15 version of the 5.0.x family, as this is not
considered production-ready.
Another new feature, profiling, was surprisingly added in version 5.0.37, well after
the 5.0.x family was branded as production-ready.
MySQL 5.0 Features
[ 266 ]
Views
MySQL 5.0 introduced support for named, updatable views. A view is a derived
table??”consider it as a virtual table??”whose definition is stored in the database. A
SELECT statement done on one or more tables (or even on views) is stored as a view
and can itself be queried. Views can be used to:
Limit the visibility of columns (do not show the salary)
Limit the visibility of rows (do not show data for specific world regions)
Hide a changed table structure (so that legacy applications can continue
to work)
As a view has itself some permissions attached to it, it is easier to GRANT permissions
on the view as a whole, rather than defining cumbersome column-specific privileges
on the underlying tables.
Pages:
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243