Смердокрыл Posted February 6, 2017 Share Posted February 6, 2017 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. or not Link to comment Share on other sites More sharing options...
SQL Insert loop
By Смердокрылin Serverside
Recommended Posts