find in which database the table is located

Question

i am working in mysql. I need to find the database within which the a particular table is located. Is that possible in mysql?

Answer 1

select table_name,table_schema
from information_schema.tables
where table_name = 'your_table'

Answer 2

if you know wich database you have How to check if mysql database exists

or do you just want to search local for devleopement?

using heidisql or mysql workbench?