O'Reilly logo

Mastering phpMyAdmin 3.3.x for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17. Supporting MySQL 5.0 and 5.1

MySQL 5.0 introduced a number of new features that calmed down a number of developers and industry observers who were claiming that MySQL was inferior than competitor products .Views, stored procedures, triggers, a standard INFORMATION_SCHEMA, and (more recently) a profiling mechanism are now present in the MySQL spectrum.

Among the new features of MySQL 5.1, the ones that relate to a web interface (for example, partitioning and events) are supported in phpMyAdmin.

Activating support for views

MySQL 5.0 introduced support for named and updatable views. A view is a derived table (consider it a virtual table) whose definition is stored in the database. A SELECT statement done on one or more tables (or even ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required