I've got a buddypress installation on a pre-existing wordpress site. There are about 400 users and I need each to be pre-joined to a couple of groups. I can see in the database where these records need to go, and what data items are needed but I really don't want to manually input the records!
What I want is to create a new row in a given table for every user ID. The user ID needs to populate one field while the other fields are set.
Can anyone out there tell me what I should do? I use the free tools out of MySQL to administer the database.