MySQL 可视化查询生成器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2506610/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Visual Query Builder
提问by johnnyArt
If been using "dbForge Query Builder" lately and I'm gotten used to the ease of building and testing a query, specially for those complex ones with inner joins, aliases and multiple conditionals.
如果最近一直在使用“dbForge Query Builder”并且我已经习惯了构建和测试查询的便利性，特别是对于那些具有内部连接、别名和多个条件的复杂查询。
The expiry date of the trial is about to come, and while wanting to remain on the legal side for this I'd rather not pay the 50USD it costs (although I must say it's pretty cheap for what it does).
审判的到期日即将到来，虽然我想为此保持法律地位，但我宁愿不支付 50 美元的费用（尽管我必须说它的作用非常便宜）。
So my question would be: Are there any free alternatives to replace this visual query builder? I've failed to find any and fear that my only two options are paying for it, or going to the dark side.
所以我的问题是：是否有任何免费的替代品可以替代这个可视化查询构建器？我没有找到任何并担心我唯一的两个选择是为此付出代价，或者走向黑暗的一面。
回答by Sergey Smagin
You may try FlySpeed SQL Query. It has the same powerful visual query builder and it's free if you don't need data export and printing.
你可以试试FlySpeed SQL Query。它具有同样强大的可视化查询构建器，如果您不需要数据导出和打印，它是免费的。
回答by jsist
回答by Kristian
I have found SQLeo, which I will use to show my colleagues how to build SQL queries. It is Java-based, so it will run on virtually any platform.
我找到了SQLeo，我将用它来向我的同事展示如何构建 SQL 查询。它基于 Java，因此几乎可以在任何平台上运行。
You will also need to install MySQL's Java Connectorfor SQLeo to be able to connect.
您还需要安装MySQL 的 Java Connectorfor SQLeo 才能进行连接。
回答by MindStalker
Think of it in terms of how much money/time it will help you make/save in the long run. Consider it a business expense. Yes, there are other free query builders out there, but they all take time to learn/get used to. If your happy with this one I'd say go for it.
从长远来看，它可以帮助您赚取/节省多少金钱/时间。将其视为业务费用。是的，还有其他免费的查询构建器，但它们都需要时间来学习/习惯。如果你对这个满意，我会说去吧。
That aside there generally are several ways you can reinstall the program and get one more month out of your free-trial if your still not quite sure its worth it.
除此之外，如果您仍然不太确定它是否值得，您通常可以通过多种方法重新安装程序并从免费试用期中再获得一个月的时间。
回答by DevGuy
Try EasyQueryBuilder.
It requires some configuration for your database at start but after that it's very easy to build queries with this tool - even for non-experienced users.
它需要在开始时为您的数据库进行一些配置，但之后使用此工具构建查询非常容易 - 即使对于没有经验的用户也是如此。
回答by BRM
dbForge has an express version for MySQL that is free. I use the express version for MSSQL all the time.
dbForge 有一个免费的 MySQL 快速版本。我一直使用 MSSQL 的 express 版本。
回答by Filson Manley
EASY QUERY BUILDER is anything but easy if you're using MYSQL. Building a connection is impossible and their documentation is nonexistent. Don't waste your time.
如果您使用 MYSQL，EASY QUERY BUILDER 绝非易事。建立连接是不可能的，他们的文档也不存在。不要浪费你的时间。
