把以100000+4位随机码的登录账号(比如1000001234),赋予制单页面的权限,怎么写sql啊
insert into sys_user_role (user_id,role_id,office_id) select id,'000101100000000004UP',company_id from sys_user where sys_user.login_name like '100000%';
insert into sys_user_role (user_id,role_id,office_id) select id,'000101100000000004UP',company_id from sys_user where sys_user.login_name like '100000%';