> Basically, what I would like to do is associate a human readable label with > each column (in the comment field) so that I can automatically generate > web-based forms for any given table. The script would look at the column's > metadata, display the appropriate HTML element, and display the > corresponding label read from the column field.
MySQL could do something that would make MySQL more complete and more able to satisfy these Codd rules: 0. A relational database must be able to manage databases entirely through its relational capabilities. 1. The Information Rule. All information in a relational database (including table and column names) is represented explicitly as values in tables. The metadata would be loaded into tables (real, virtual, heap or temporary?). It would be refreshed as necessary by mysqld, when processing ALTER, DROP, CREATE, etc. Normal SELECTs would be used to efficiently view those metadata tables. Why should it be necessary for tools such as MySQLfront to use?: SHOW TABLE STATUS, SHOW FIELDS FROM table, SHOW KEYS FROM table. Thanks, Stephen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
