We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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
The text was updated successfully, but these errors were encountered:
1.这个设计语法解析,我得研究一下 2.这个没看明白
Sorry, something went wrong.
No branches or pull requests
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
The text was updated successfully, but these errors were encountered: