How do I get the name of the database to which my table belongs?

Question

My query is "select column_name,table_name from information_schema.columns". This query returns a number of columns and tables. Now, I want to determine the name of the database that corresponds to the returned table names. How do I accomplish this?

Answer 1

select database();

Is that it? The current schema?

Answer 2

mysql> describe information_schema.columns;
+--------------------------+
| TABLE_CATALOG            |
| TABLE_SCHEMA             | <=== this one (schema == database)
| TABLE_NAME               |
| COLUMN_NAME              |
.......