Jump to content

SQL Insert loop

By Смердокрыл
in Serverside

Recommended Posts

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


 skarnnoggitlogpost.thumb.jpg.d752b4e8541

Link to comment
Share on other sites

×
×
  • Create New...