下面是一个sql 语句 想要permission_id 从 41 到 126,其他字段不变 应该如何写sql,INSERT INTO logistics
.auth_role_permission
(role_id
, permission_id
, create_time
, deleted
) VALUES ( 1, 41, '2024-05-09 17:03:09', 0);
解决:
DELIMITER $$
CREATE PROCEDURE InsertRolePermissions()
BEGIN
DECLARE v INT;
SET v = 41;
WHILE v <= 126 DO
INSERT INTO `logistics`.`auth_role_permission`(`role_id`, `permission_id`, `create_time`, `deleted`)
VALUES (1, v, '2024-05-09 17:03:09', 0);
SET v = v + 1;
END WHILE;
END$$
DELIMITER ;
CALL InsertRolePermissions();
执行完结束后 在删除 存储过程:
DROP PROCEDURE IF EXISTS InsertRolePermissions;