Hello,
Yes this looks as a great idea. Please post your code to our patch tracker
http://sourceforge.net/tracker/?group_id=23067&atid=377410
because my mail system did not deliver all of your script intact.
Thanks,
Marc Delisle
Thomas Bley a écrit :
Hello,
most database tools offer auto-completion for writing SQL queries (e.g.
pgAdmin3, pl/sql developer).
I think it would be great to have this feature in phpMyAdmin.
I've written a small demo to offer sql auto completion for a normal
textarea (tested with MySQL5 and Firefox2).
In this first draft, auto-complete is done for databases, tables and
columns. The user types some sql in the textarea and the selectbox on
the right side gets filled automatically. When typing in the textarea,
some keys are bound to the selectbox (cursor up, cursor down, escape and
enter), so the user can directly insert values from the selectbox to the
textarea.
What do you think about it? Would you like to add it to one of the next
releases?