live/quick mysql query builder/viewer

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?

---

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.

---

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.

---

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.