一、存储过程定义DROP PROCEDURE IF EXISTS get_child_organiz;DROP TABLE IF EXISTS tmplist;DELIMITER $$CREATE PROCEDURE get_child_organiz (IN parent_organiz_id INT)BEGINDROP TABLE IF EXISTS tmplist;CREATE TABLE tmplist(id INT(11),NAME VARCHAR(35),parentid INT(11));IN