基于 Web 的 MySQL 查询生成器？
我对 MySQL 还很陌生，但自从过去几个月第一次学习以来，我已经有了很大的进步。
不幸的是，我是我工作的公司中唯一了解 MySQL 和数据库的人。
因此，我正在寻找一个基于 Web 的临时查询生成器，它本质上将为我的同事编写查询（我希望它连接到 phpmyadmin。）
我偶然发现了这个开源项目，http://www.ajaxquerybuilder.com/ 但我不知道如何将其连接到我的托管站点上的 phpmyadmin。 （由于缺乏文档，更重要的是我的经验。）
如果有人可以提供有关如何执行此操作的建议，或者可以完成这项工作的类似开源项目，我将不胜感激。 （该程序不必采用 AJAX。）
I am fairly new to MySQL, but have improved drastically since first learning over the past few months.
Unfortunately, I am the only one that has any knowledge of MySQL and Databases for the company I work for.
As a result I'm looking for an ad hoc query builder that is web based that essentially will write the query for my co-workers (I'd like it to connect to phpmyadmin.)
I stumbled across this open source project, http://www.ajaxquerybuilder.com/ but I cannot figure out how to connect it to phpmyadmin on my hosting site. (Due to lack of documentation, and more importantly my experience.)
If anyone can offer a suggestion on how to go about doing this, or a similar open source project that could do the job it would be most appreciative. (The program does not have to be in AJAX.)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在 Linux 服务器中运行 AjaxQueryBuilder 的快速指南：
0) 我猜您已经在某个地方有一个 mysql 服务器。
1）安装并配置Apache，Java JDK，然后是Tomcat服务器（我使用的是Tomcat7）。测试它是否有效！
2）安装mysql-jdbc-connector（基本上将.jar文件复制到Tomcat的Lib文件夹中） - 检查权限！
3) 将 AjaxQueryBuilder 文件复制到 ROOT 文件夹（再次检查权限！）
4) 根据您的要求将设置更改为 META-INF 文件夹中的 context.xml 文件：
5) 检查一切是否正常！
我必须“跟随我的直觉”找到这个安装步骤，所以也许这不是最好的方法，但由于作者网站上缺乏文档，这是我能够运行它的唯一方法。
A quick guide to run AjaxQueryBuilder in a Linux server:
0) I guess that you already have a mysql server somewhere.
1) Install and configure Apache, Java JDK and then a Tomcat server (I used Tomcat7). Test that it works!
2) Install the mysql-jdbc-connector (Basically copy the .jar file into the Lib folder of Tomcat) - Check the permissions!
3) Copy the AjaxQueryBuilder Files to the ROOT folder (check the permissions again!)
4) Change the settings into the context.xml file in the META-INF folder to your requirements:
5)Check that all is working!
I had to "follow my intuition" to find this installation steps, so maybe it is not the best way to do it but due to the lack of documentation in the author's site it is the only way I was able to run it.
您可以将数据库下载到您自己的计算机/远程连接到它，然后使用类似 Navicat 或 Toad for MySQL 是免费的。
you can download the database to your own computer / connect remotely to it, and then use programs like Navicat or Toad for MySQL which is free.