Hi
Dne Sun, 20 Mar 2011 21:46:55 +0530 Samiran Raj Boro srajbr@gmail.com napsal(a):
I have experimented with the current capability of phpmyadmin with stored procedures, triggers, routines and events. As this project aim to create an user friendly interface in phpmyadmin I have some ideas to improve it and also some questions.
Currently phpmyadmin supports the above mention features of mysql only with sql queries. While creating procedures with ";" in between delimiter have to be changed. My view is why the user have to take care of it. We can pass some default delimiter to PMA_sqlQueryForm with the delimiter added to our query. So for that I suggest to create separate query box to deal with those things and this would be in a tab "Routines" for each database. It can even be better if we display the list of routines in the database page (the page one gets by selecting a database) and also the names of the trigger associated with a table when we browse it.
You can already define a delimiter for SQL query, which is also used by current way of editing procedures.
Again as ALTER PROCEDUREhttp://dev.mysql.com/doc/refman/5.5/en/alter-procedure.html, ALTER FUNCTION http://dev.mysql.com/doc/refman/5.5/en/alter-function.htmldoes not allow us to change the parameters or the body, we can make a interface to change its parameters and body. We can program such a way it automatically drops it and create it with the same name with the modified changes.
Yes, it is needed to drop and create it again in such case.
Are my ideas meet the needs of phpmyadmin. Please let me know and suggest to make it better.
I've also updated the ideas page to describe in more details what is expected here. But you are always welcome to be creative in your proposal, because we will choose only the best one out of all.