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?