Is there such a thing that will allow you to create a mysql query and view its results live? Almost like an ajax sort of live search results kind of thing, so each character i type in will affect my result?
+1
A:
That wouldn't be very practical as nearly every other keypress would raise errors against MySQL for syntax issues. I'd just suggest you get Query Browser, and hit "Execute" when you're ready to see results.
Jonathan Sampson
2010-01-08 06:33:31
Such a system could only query the DB upon insertion of a delimiter such as `;`.
Alix Axel
2010-01-08 07:25:43
+1
A:
Yes, only what you type will just be a part of the query.
You write javascript to fire off an ajax query for each character typed (check out xajax) then your PHP server will make a query using the key you are typing and send back a results update.
Don
2010-01-08 06:59:04
+1
A:
Here is a list of all the MySQL AJAX clients I know:
- SQL Buddy (Screens)
- MonoQL (Demo)
- TurboDBAdmin (Offline?)
I'm not sure if they provide real-time response, but they are a faster alternative to phpMyAdmin.
Alix Axel
2010-01-08 07:38:35