strago Posted August 4, 2015 Share Posted August 4, 2015 php 5.5.42 Database name: forumsTable name: phpbb_usersRow name: user_id What SQL query can I run in phpMyAdmin to update the user_id in every row, adding 8447002 to each user_id? Quote Link to comment Share on other sites More sharing options...
requinix Posted August 4, 2015 Share Posted August 4, 2015 Have you tried to figure it out yourself? It's really straight-forward. I mean, it's not like MySQL can't do basic addition. Quote Link to comment Share on other sites More sharing options...
Solution strago Posted August 4, 2015 Author Solution Share Posted August 4, 2015 lol...yah, that was easy!!!! UPDATE phpbb_users SET user_id = (user_id + 8447001) Quote Link to comment Share on other sites More sharing options...
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.