Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Show Procedure Code Mysql Statement

Example of Show Procedure Code Mysql Statement:

CREATE PROCEDURE p1 ()
BEGIN
DECLARE fanta INT DEFAULT 55;
DROP TABLE t2;
LOOP
INSERT INTO t3 VALUES (fanta);
END LOOP;
END
SHOW PROCEDURE CODE p1

Example of Mysql Show Procedure Code


SHOW PROCEDURE CODE proc_name