mango icon indicating copy to clipboard operation
mango copied to clipboard

mysql d递归查询语法解析存在问题

Open guojialin520 opened this issue 5 years ago • 1 comments

String sql ="SELECT N_ID FROM(SELECT @ids AS _ids,( SELECT @ids := GROUP_CONCAT( N_ID ) FROM T_DEPARTMENT" + " WHERE FIND_IN_SET( N_PARENT_ID, @ids ) ) AS cids," + "@l := @l + 1 AS LEVEL FROM T_DEPARTMENT,( SELECT @ids :="+id+" , @l := 0 ) b WHERE @ids IS NOT NULL) ID," + "T_DEPARTMENT DATA WHERE FIND_IN_SET( DATA.N_ID, ID._ids ) "; 1::=符号解析错误 2:是否支持原始sql语句传递,可以指定放行的sql

guojialin520 avatar Oct 15 '20 03:10 guojialin520

1.这个设计语法解析,我得研究一下 2.这个没看明白

liangyanghe avatar Nov 17 '20 10:11 liangyanghe