INSERT INTO bs_sys_role_permission (role_id, permission_id, state, remark, version, create_time ) SELECT 33 as role_id,permission_id,state,remark,version,NOW()
FROM
bs_sys_role_permission
WHERE
role_id = 31;
insert into 通过Select来实现
最新推荐文章于 2021-08-15 09:15:48 发布