摘要：
1. 存储过程与游标循环 DROP PROCEDURE IF EXISTS LES_PARENT_DATA_MIGRATE; DELIMITER ;; CREATE PROCEDURE LES_PARENT_DATA_MIGRATE() BEGIN DECLARE done INT DEFAULT 阅读全文
摘要：
1. 查询所有父节点 SELECT T2.* FROM ( SELECT @R AS _id, ( SELECT @R := PARENT_ID FROM sys_org WHERE ID = _id ) AS PARENT_ID, @L := @L + 1 AS LVL FROM (SELECT 阅读全文