CodeIgniter Working with multiple Databases

Question

I am trying to list all the mysql databases and their respective tables, I am currently using this, but can anybody recommend if there is any better way.

$q = $this->db->query('SHOW DATABASES');
$databases = $q->result_array();

foreach($databases as $db) {
  $this->db->query('USE '. $db['Database']);

  $q = $this->db->query('SHOW TABLES');
  $tables = $q->result_array();             
}

Fanis Hatzidakis · Accepted Answer · 2010-09-26 17:30:28Z

2

You can use the information_schema special database, which has tables that describe all the other databases, tables, and columns.

That way you only need 1 query:

SELECT table_schema, table_name
FROM information_schema.tables
ORDER BY table_schema, table_name;

answered Sep 26, 2010 at 17:30

Fanis Hatzidakis

5,3401 gold badge35 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shishant Over a year ago

I am a learner can you please tell me whether this information_schema table is available for all default MySQL Installations? Also is it available v4+ or v5+?

Fanis Hatzidakis Over a year ago

@Shishant it was only added to mysql starting in version 5.0.2: dev.mysql.com/tech-resources/articles/mysql-datadictionary.html - before that you should use SHOW as you have already.

Collectives™ on Stack Overflow

CodeIgniter Working with multiple Databases

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related