Page 1 of 1
list of all tables and fields in database
Posted: Wed Sep 04, 2002 10:32 am
by noguru
Hi
How do I retrieve a list of all the tables and fields that are in my database? What mysql functions can be used for this?
Thanks
Posted: Wed Sep 04, 2002 11:40 am
by Tzicha
THat shows the tables in your current database
That gives a description of a table
For better results check the MySQL manual:
http://www.mysql.com/doc/
Posted: Wed Sep 04, 2002 12:54 pm
by noguru
thanx
i actually meant to say "what functions are to be used in php?", but i have sorted that out eventually using mysql_list_tables and mysql_field_name.
i've managed to connect with the command line as well
after typing "show tables" and enter, you must actually type "go" enter or else nothing will be displayed
thanx for the help