[Phpmyadmin-devel] {ATTENTION} Auto Complete for sql window

[Marc Delisle]

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?