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
list of all tables and fields in database
Moderator: General Moderators
Code: Select all
SHOW TABLESCode: Select all
DESCRIBE <tablename>For better results check the MySQL manual:
http://www.mysql.com/doc/
- noguru
- Forum Commoner
- Posts: 61
- Joined: Thu Jun 06, 2002 4:03 am
- Location: Just north of the City Of Gold, Land of Milk and Honey
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
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