list all databases / tables (mysql)

[Jassim Rahma]

I want to know how can I list all database in mysql? and also how to show all tables within the selected database?

[PIEBALDconsult]

You can't (as far as I know). List tables (if I recall correctly). Edit: It's show tables and also describe <table>

[Mycroft Holmes]

Having limited (none) experience with mysql I can only recommend that you look into the system table, sql server has a master database that stores the db information, I'm pretty sure mysql will have something similar. There should be system tables that hold the meta data for the database somewhere in mysql, research will be required. There are lots of responses from Google for this enquiry.

Never underestimate the power of human stupidity RAH

[Lost User]

jrahma wrote:

I want to know how can I list all database in mysql?

By keeping track if the tables you make. Create a tabled called "MyTables", and add an entry whenever you successfully issue a CREATE command :)

I are Troll :suss: