How to watch stored procedures

Since I work on MySQL by using phpMyAdmin, is there anyone saying to me i=
f and how it's possibile to see the code of a stored procedure that I've =
created? For example on Oracle I use sql-developer but with phpMyAdmin is=
it possible to see the whole code of a procedure or of a trigger after c=
reating it?

Thanks!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: How to watch stored procedures

--0016363b8510f7c96a0483c93f2e
Content-Type: text/plain; charset=ISO-8859-1

In phpmyqdmin in SQL window type :
show create procedure procedureName;
eg; SHOW CREATE PROCEDURE circle_area; in SQL

Check more on :
http://adminlinux.blogspot.com/2009/12/mysql-tips-verify-dat abase-objects.html

Thanks


On Fri, Apr 9, 2010 at 1:00 PM, alba.albetti wrote:

> Since I work on MySQL by using phpMyAdmin, is there anyone saying to me if
> and how it's possibile to see the code of a stored procedure that I've
> created? For example on Oracle I use sql-developer but with phpMyAdmin is it
> possible to see the whole code of a procedure or of a trigger after creating
> it?
>
> Thanks!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>
>


--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--0016363b8510f7c96a0483c93f2e--