- 在
mysql中構(gòu)建函數(shù)
BEGIN
DECLARE str varchar(100);
DECLARE cid varchar(100);
SET str = '$';
SET cid = rootId;
WHILE cid is not null DO
SET str = concat(str, ',', cid);
SELECT group_concat(id) INTO cid FROM depts where FIND_IN_SET(parent_id, cid) > 0;
END WHILE;
RETURN str;
END
- 查詢語句
select * from users where dept_id in (select id from depts d where FIND_IN_SET(id,getChildList(1)));
- 還是附上完整的
sql文件帶勁
鏈接: https://pan.baidu.com/s/1SXGLFdUwPQbyS3le4O81-A 密碼: 9zw8
剛剛深入點(diǎn)去接觸 MySql，以前的我對數(shù)據(jù)庫的理解真是太天真了。
參照鏈接：https://blog.csdn.net/u014033756/article/details/70567746
