开发者

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜