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.
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 ...