mysql 存储过程 when MySQL 存储过程 if

CREATE DEFINER=`root`@`localhost` PROCEDURE `system_depatment_insert`(IN dept_name VARCHAR(50),IN dept_parent_id VARCHAR(32),IN dept_hava_child VARCHAR(1),IN dept_description VARCHAR(100))
BEGIN
	IF(dept_parent_id IS NULL || dept_parent_id = '') THEN
		INSERT INTO oa.department VALUES(REPLACE(UUID(),'-',''),dept_name,'00','顶层部门',dept_hava_child,dept_description,NOW());
	ELSE
		SET @dept_parent_name = (SELECT parent_name FROM oa.department WHERE id = dept_parent_id);
		INSERT INTO oa.department VALUES(REPLACE(UUID(),'-',''),dept_name,dept_parent_id,dept_parent_name,dept_hava_child,dept_description,NOW());
	END IF;
    END$$

记：mysql中判断使用=，编程习惯了老是写==，很容易忽略