As I putter around the MySQL "INFORMATION_SCHEMA", I am finding lots of undocumented behavior for fields that should be straightforward. For example, the "VIEWS" table holds information about views, and the "VIEW_DEFINITION" field contains the view definition, right?Well, when I was looking at the "VIEW_DEFINITION" today, I noticed an odd thing. Even though I had permissions to see the view definition (as proven by the "SHOW CREATE VIEW

This is the fourth part in the "MySQL 5.0 New Features" series. Trudy Pelzer covers the MySQL 5.0 Data Dictionary using detailed examples, source code, and hands-on exercises. (2005-03-23)