是否有具有语法、逻辑格式等功能的平台无关的 SQL 查询构建器?
是否有任何轻量级工具可以独立于与特定数据库关联的主要应用程序/实用程序而轻松地编写 SQL?
我最近发现自己正在使用 MySQL、Access 和 MySQL。 现在 MS-SQL 并使用 Notepad++ 来构建查询,因为它提供了基本语法突出显示,可以帮助我不熟悉的眼睛,但没有逻辑格式化 - INNER JOIN、WHERE 等的新行,连续参数的缩进,我什至敢说 IntelliSense - 那之类的事情。
特别是在重新调整显示为难以理解的块的现有查询时,如果能够将其粘贴到某处,单击按钮并以更人性化的格式显示,那就太好了。
存在这样的工具吗?
编辑:感谢您的建议。 特别是,SQLinForm 具有我理想中想象的那种细粒度控制。
遗憾的是,只有在线版本是免费的,OSS 独立应用程序(不是 Java - 口香糖!)会更好,因为 SQL 并不完全是我工作的主要焦点,而且我看不到我在豆子计数器上挥霍甚至 30 美元,所以我不要为修复他们糟糕的报告而头疼。
还有吗?
编辑2:哎呀,似乎以前已经问过这个问题了。 当我检查时,我显然没有在寻找正确的东西。 搜索工具名称,或通过 Google,提出了许多类似的问题 - 投票结束。
Are there any lightweight tools that allow easy-to-read crafting of SQL independently of the main apps/utilities associated with a particular database?
I lately find myself working with MySQL, Access & now MS-SQL and use Notepad++ to build queries as it provides basic syntax highlighting that helps my unfamiliar eyes, but no logic formatting - new lines for INNER JOIN, WHERE etc., indenting of continuing parameters, dare I say it even IntelliSense - that kind of thing.
Particularly when re-jigging an existing query that is presented as an incomprehensible lump, it would be nice to be able to paste this in somewhere, click a button and have it displayed in a more human-friendly format.
Does such a tool exist?
Edit: Thanks for the suggestions. In particular, SQLinForm has the kind of fine-grained control I was ideally imagining.
Pity only the online version is free, an OSS standalone app (not Java - gumph!) would be preferable as SQL is not exactly a main focus of my work and I can't see me swinging even $30 past the bean counters just so I don't get a headache trying to fix their crummy reporting.
Any more?
Edit 2: Oops, seems this has been asked before. I wasn't obviously searching for the right thing when I checked. Searching on the tool names, or via Google, brings up many similar questions - voted to close.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
我过去用过这个来使一些丑陋的sql有点可读: http://www.dpriver .com/pp/sqlformat.htm
I used this on in the past to make some ugly sql somewhat readable: http://www.dpriver.com/pp/sqlformat.htm
我过去使用过 SQLInform 并取得了相当不错的结果 - 它再次以合理的方式格式化您粘贴的任何 SQL准确性。
I've used SQLInform in the past with pretty good results - again it formats any SQL you paste in with reasonable accuracy.
我主要使用 oracle SQL Developer。 但这并不完全是轻量级的。
MS-SQL-Server 开发 UI 也适用于此。 (我认为它们也适用于不同的数据库)。
Toad 是另一个不错的 UI。 (但也不轻)
I have use the oracle SQL Developer for this mainly. But this is not exactly lightweight.
The MS-SQL-Server development UI is noce for this too. (I Think they work for different databases too).
Toad is another nice UI for this. (But not lightweight too)
我还没有尝试过,但我看到至少有一个 SQuirreL 插件提到了格式化。 免费/开源/Java。
http://www.squirrelsql.org/index.php?page=plugins
I haven't tried it, but I see there is at least one SQuirreL plugin that mentions formatting. Free / open source / Java.
http://www.squirrelsql.org/index.php?page=plugins