Prem Tiwari - - Mysql
If you want to show the procedure code in MySQL, then this tutorial is for you. In this tutorial, I am going to share how to show the store procedure code syntax in MySQL.
Open the query window and copy paste below command:
1 | SHOW PROCEDURE CODE proc_name |
In the above MySQL command, change the proc_name as your store procedure name.
Below is the complete example of Store Procedure Code Syntax
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | mysql> DELIMITER // mysql> CREATE PROCEDURE p1 () -> BEGIN -> DECLARE fanta INT DEFAULT 55; -> DROP TABLE t2; -> LOOP -> INSERT INTO t3 VALUES (fanta); -> END LOOP; -> END// Query OK, 0 rows affected (0.00 sec) mysql> SHOW PROCEDURE CODE p1// +-----+----------------------------------------+ | Pos | Instruction | +-----+----------------------------------------+ | 0 | set fanta@0 55 | | 1 | stmt 9 "DROP TABLE t2" | | 2 | stmt 5 "INSERT INTO t3 VALUES (fanta)" | | 3 | jump 2 | +-----+----------------------------------------+ 4 rows in set (0.00 sec) |
Prem Tiwari is the founder of FreeWebMentor.com and also a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby and also he has been a regular speaker of WordPress sessions in various IT Companies. View all posts by Prem Tiwari
Tags: how to see the stored procedure in mysql, how to view created stored procedure in mysql, how to view stored procedure code in mysql, how to view stored procedure in mysql, how to view stored procedure in mysql workbench, show create procedure
