开发者

find in which database the table is located

开发者 https://www.devze.com 2023-03-06 16:43 出处:网络
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

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

精彩评论

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