Carlos Bergueira wrote:
Hi,
I need to know some things:
- 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 ?). I use PHP to write output.
- 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...
Thanks in advance.
Cumprts, Carlos Bergueira
O SAPO j� est� livre de v�rus com a Panda Software, fique voc� tamb�m!
Clique em: http://antivirus.sapo.pt
Hi Carlos,
If you go to http://www.php.net and search for mysql you will find a number of different functions that will get you the info you need. Also try http://dev.mysql.com/doc/mysql/en/index.html (The english version, there are several possibly in languages which you may prefer)
If you need further functionality you can look at http://pear.php.net and look for the DB libraries. They have many functions to return column names etc. along with examples.
If you want practical examples, look at phpMyadmin (http://www.phpmyadmin.net) as this does almost exactly what you are trying to do, this is an open source product and you get many, many examples of your request.
Regards
--
David Logan South Australia
when in trouble, or in doubt run in circles, scream and shout
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
