Hi, Carlos > - Where can i get (url of document) the MySql database fields ? (For example, i > need to list all tables of a database (database: mydb) and for each table > properties like comments, size, record number, etc ?).
You should use "SHOW TABLE STATUS" it will provide you with any info that you need. > - I need to do the same with all fields of each table. (The output i need is > explain above) > Fields: field(0), field(1), field(2), etc.. > Records: 1,MyClient_1,56888554, etc... You can use any of the: DESCRIBE `table_name` SHOW COLUMNS FROM `table_name` But the most verbose output you will get using: SHOW FULL COLUMNS FROM `table_name` This will show you collation, privileges the user has for the each column and per-column-comment. Verbose descriptions of the syntax can be found at http://dev.mysql.com/doc/mysql/en/show.html Good luck. Gabriel PREDA dev.falr.ro www.amr.ro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
