Paul13 Posted July 30, 2014 Report Share Posted July 30, 2014 I have need to change the Group to a lot of customers.Can someone help me with the sql command in order to change the group to all clients?Thanks in advance Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted July 31, 2014 Report Share Posted July 31, 2014 Be sure to backup your database before making any changes to it directly. If you are wanting to change all clients from one group to another, then you can run: UPDATE `clients` SET `client_group_id` = '2' WHERE `clients`.`client_group_id` = '1'; That will result in all clients from group 1 (the default group) being changed to group 2. Michael 1 Quote Link to comment Share on other sites More sharing options...
Question
Paul13
I have need to change the Group to a lot of customers.
Can someone help me with the sql command in order to change the group to all clients?
Thanks in advance
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.