mango
mango copied to clipboard
mysql d递归查询语法解析存在问题
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
1.这个设计语法解析,我得研究一下 2.这个没看明白