摘要：update test_table set user_id = 112 where id in (select id from ( select id from test_table where number in ( 008667 , 008706 , 008707 ) ) as s); 字段操作 阅读全文

摘要：原先sql获取角色对应的权限信息： select a.*, group_concat(b.auth_name) as auth_name from sh_role a left join sh_auth b on find_in_set( b.auth_id, a.role_id_list) gro 阅读全文