Web-based Visual Query Designer Code
Web-based Visual Query Designer is a tool for generating SQL queries.
Status: Beta
Brought to you by:
swapnilmj
Menu
▾
▴
Tree [deddae] master / History
| File | Date | Author | Commit |
|---|---|---|---|
| ajax | 2012-06-30 |
swap jo
|
[542ca7] initial commit |
| coffee | 2013-09-14 |
swapnilmj
|
[1c681c] various changes |
| css | 2013-10-06 |
swapnilmj
|
[deddae] made table selection box transparent |
| images | 2012-06-30 |
swap jo
|
[542ca7] initial commit |
| js | 2012-07-27 |
swapnilmj
|
[69b970] loads table list on click of addTable btn ; Fad... |
| .gitignore | 2012-10-18 |
swapnilmj
|
[92fd01] minor |
| LICENSE | 2012-06-30 |
swap jo
|
[542ca7] initial commit |
| conn.php | 2013-09-18 |
swapnilmj
|
[9cea0a] minor changes |
| index.php | 2012-10-13 |
swapnilmj
|
[888ac0] Minor changes |
| lib.php | 2012-06-30 |
swap jo
|
[542ca7] initial commit |
| readme.md | 2013-09-18 |
swapnilmj
|
[315c41] target=_blank for online demo |
| table_sel_list.php | 2012-06-30 |
swap jo
|
[542ca7] initial commit |
Read Me
Web-based Visual Query Designer
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 supplement to your MySQL front-end tool (like
phpMyAdmin ).
Why not try the online demo ?
Sourceforge.net project link (mirror): http://sourceforge.net/projects/web-vqd/
Installation
Extract all the files to the www folder of your web server. Open conn.php
file and set the $username and $password for your MySQL database.
Limitations (as of now)
-
A join can be made between 2 tables only on one set of condition
-
Aggregate queries and sub-queries are not yet supported
License
Web-based Visual Query Designer is an open source software released under the
MIT License.
Feedback
Please let me know if you find it useful.
Swapnil Joshi
swapnil [dot] gnu [at] gmail.com