MYSQL - Add several data entries in a specific format
MYSQL - Add several data entries in a specific format
Hi guys.
I'm an admin in a gaming community and we just began setting up a Minecraft server. Since it runs on Bungeecord, there are several server instances—each needing the same permission settings. I've configured all servers to use LuckPerms for saving, editing, writing, and deleting permissions, as well as groups and tracks from a MYSQL database. Everything is working fine.
But adding permissions one by one for each group is tedious, even though it's convenient because of inheritance. I've tried using the SQL command line in phpmyadmin to insert multiple permissions at once. The issue is that the permissions for each group are stored in a different table called "luckpermsgroup_permissions" with columns like id, name, permission, value, etc.
I'm looking for the best way to insert many values into this table while ensuring that each value also assigns the "moderator" permission to the column named "NAME". I'm not sure how to phrase it clearly, but I hope the images here will clarify the database structure.
I'm just an idi*t. I thought what I tried in my screenshots would work, but I totally missed the commas in between the values xD