find in which database the table is located
i am working in mysql. I need to find the database within which the a particular table is locat开发者_JAVA百科ed. Is that possible in mysql?
select table_name,table_schema
from information_schema.tables
where table_name = 'your_table'
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?
精彩评论