dongmacheng3222 2017-04-30 14:00
浏览 17
已采纳

将MySQL模式添加到MySQL Workbench?

If this is a super basic question I apologize; I'm still trying to grok MySQL and my options on interfacing with it.

I'm wondering if I'm able to add the mysql schema to MySQL Workbench? I can see and access it via PhpMyAdmin and the command line. I'm also able to query a mysql table (user, for example) from Workbench itself.

I'm mostly just curious if I can add it to the schema section in the lower left hand side of Workbench. I'm using version 6.3.

Thanks for your time and suggestions!

Edit: To better clarify, I'm just wondering if I can view the schema in Workbench like I can in PhpMyAdmin.

enter image description here

  • 写回答

2条回答 默认 最新

  • drh96824 2017-05-01 08:49
    关注

    MySQL Workbench by default hides system tables (that is PERFORMANCE_SCHEMA, INFORMATION_SCHEMA and mysql). In the preferences (SQL Editor -> Show Metadata and Internal Schemas) you can enable them. After a restart of Workbench you will get them in the schema tree.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥50 ZYNQ7020双核FLAHS烧写的问题
  • ¥20 ue 5 中想要实现第一人称人物左右行走摆动的效果,摄像头只向右摆动一次(关键词-结点)
  • ¥15 钢岔管添加弹性约束模拟围岩作用
  • ¥15 AD9164瞬时带宽1.8G,怎么计算出来?
  • ¥15 鼠标右键,撤销删除 复制 移动,要怎样删除
  • ¥15 使用MATLAB进行余弦相似度计算加速
  • ¥15 服务器安装php5.6版本
  • ¥15 我想用51单片机和数码管做一个从0开始的计数表 我写了一串代码 但是放到单片机里面数码管只闪烁一下然后熄灭
  • ¥20 系统工程中,状态空间模型中状态方程的应用。请猛男来完整讲一下下面所有问题
  • ¥15 我想在WPF的Model Code中获取ViewModel Code中的一个参数