MySQL 5.0 introduced a number of new features. The announcement of these features calmed down a number of developers and industry observers who were claiming that MySQL was an inferior product as compared to some competitors' products, which already had these features. 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 the named, and updatable views. A view is a derived table (consider it a virtual table) whose definition is stored ...