I have created a new channel (in this case ID#32) on an existing EE site install, and I need to assign it to 270 existing member groups.
Rather than clicking into every single member group and manually adding the the new channel under the 'Allowed Channels' list, I was thinking it would be easier to write an SQL Query to the 'exp_channel_member_groups' table so all group_id's (that do not have a row stating the new/required channel_id #32 number to have a row created etc, so you would have (for example) group_id 01 channel_id 32 on so on.
Can anyone advise on the correct EE/SQL scripting I would need in order to get this to happen?
Many thanks in advance for any help on this :-)