How to watch stored procedures

2010-04-09 Thread alba.albetti
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

Re: How to watch stored procedures

2010-04-09 Thread Prabhat Kumar
In phpmyqdmin in SQL window type : show create procedure procedureName; eg; SHOW CREATE PROCEDURE circle_area; in SQL goog_1193647372 Check more on : http://adminlinux.blogspot.com/2009/12/mysql-tips-verify-database-objects.html Thanks On Fri, Apr 9, 2010 at 1:00 PM, alba.albetti