How do I iterate through every record of one table to create record in another table?
I want to run an insert statement for every user in the users table. The new data will be inserted into the PERMISSIONS table.
DO WHILE EVERY USER IN USER TABLE
INSERT into permissions SET permission_user = *user ID from users table*, SET permission_grant_on = "team", SET permission_item = -1, SET permission_value = -1