[Archive] SQL Insert loop
[Archive] SQL Insert loop
02-06-2017, 03:58 PM
Original source
Hey!
I want to make an sql script that would give a certain accound all rbac permissions.
Basically, it needs to repeat the following statement:
INSERT INTO `rbac_account_permissions` (`accountId`, `permissionId`, `granted`, `realmId`) VALUES ('1', $permission, '1', '-1')
With $permission increasing every time from 1 up to 841.
I've searched the internet for quite some time, but none of the suggested methods (e.g. creating a procedure) work.
rektbyfaith
02-06-2017, 03:58 PM #1Archived author: Смердокрыл • Posted: 2017-02-06T15:58:09+00:00
Original source
Hey!
I want to make an sql script that would give a certain accound all rbac permissions.
Basically, it needs to repeat the following statement:
INSERT INTO `rbac_account_permissions` (`accountId`, `permissionId`, `granted`, `realmId`) VALUES ('1', $permission, '1', '-1')
With $permission increasing every time from 1 up to 841.
I've searched the internet for quite some time, but none of the suggested methods (e.g. creating a procedure) work.
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)