Intellij Idea Database schemas显示

在使用Intellij idea时,常常会用到它的数据库工具。今天遇到了这样一个问题:设置好mysql数据连接后,看不到数据库中有些什么表。

测试数据库连接成功
show tables命令能够看到数据

遇到的问题是下面

schemas 下面没有我的数据库

经过一翻折腾,发现解决方法其实很简单。

右键单击"schemas", 选择Database Tools\Manage Shown Schemas…,然后就能看到数据库下面的所有schema,选中要显示的后,确定。

解决方法

这样,就可以在数据库工具里直观的管理数据了。

最终结果

### IntelliJ IDEA SQL Code Completion and Quick Tips In IntelliJ IDEA, obtaining code completion and quick tips while writing SQL queries can significantly enhance productivity. To view quick documentation for any function or method related to SQL support within the editor, pressing `Ctrl+Q` provides immediate access to relevant information about classes or methods under the cursor[^1]. This feature is invaluable when working with database-specific functions or unfamiliar libraries. For more comprehensive assistance during SQL coding: - **Code Completion**: As one types an SQL statement, IntelliJ IDEA automatically suggests keywords, table names, column names, and other elements specific to connected databases. - **Live Templates**: Predefined live templates help insert commonly used SQL snippets efficiently. Users may also create custom templates tailored to project requirements. - **Database Tools Integration**: Connecting external databases through Database Tool windows allows direct interaction with schemas, enabling accurate auto-completion based on actual schema structures. ```sql -- Example of using a predefined template for selecting all records from a table named 'users' SELECT * FROM users; ``` IntelliJ IDEA’s robust plugin ecosystem further extends these capabilities by integrating additional tools that improve SQL development workflows. For instance, plugins like those mentioned in discussions around enhancing Android Studio might offer similar benefits for SQL developers seeking advanced features such as enhanced syntax highlighting or specialized refactoring options[^3].
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值