Web-based Visual Query Designer is a tool for visually generating SQL queries. Currently, it is designed only for MySQL .
Feel free to try this tool for generating simple SELECT queries for the MySQL database.
Think of it as a supplementary tool to your MySQL front-end tool (like phpMyAdmin ).
Please let me know if you find it useful.
swapnil [dot] gnu [at] gmail.com
Sourceforge.net Project page: http://sourceforge.net/projects/web-vqd/
Extract all the files to the www folder of your web server.
conn.php file and set the
$password for your MySQL database.
- Multi-table query generation is still buggy.
- A join can be made between 2 tables only on one set of condition
SELECT tbl1.* FROM tbl1 INNER JOIN tbl2 ON tbl1.fieldA = tbl2.fieldA
Web-based Visual Query Designer is an open source software released under the MIT License.