Mysql infinite subordinate sql and infinite subordinate recursive stored procedures

This article mainly talks about "mysql infinite subordinate sql and infinite subordinate recursive stored procedures". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn "mysql infinite subordinate sql and infinite subordinate recursive stored procedures"!

CREATE DEFINER= `root` @ `% `getSubAgent` (memberId INT) RETURNS varchar (4000) CHARSET utf8 BEGIN DECLARE sTemp VARCHAR (4000); DECLARE sTempChd VARCHAR (4000); SET sTemp = 0; SET sTempChd = cast (memberId as char); WHILE sTempChd is not NULL DO SET sTemp = CONCAT (sTemp,',',sTempChd); SELECT group_concat (member_id) INTO sTempChd FROM p_cps_user_agent where FIND_IN_SET (sup_member_id,sTempChd) > 0; END WHILE; return sTemp END so far, I believe you have a deeper understanding of "mysql infinite subordinate sql and infinite subordinate recursive stored procedures". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!