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? Link to comment https://forums.phpfreaks.com/topic/297611-update-mysql-data-with-some-math-using-phpmyadmin/ 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. Link to comment https://forums.phpfreaks.com/topic/297611-update-mysql-data-with-some-math-using-phpmyadmin/#findComment-1517957 Share on other sites More sharing options...
strago Posted August 4, 2015 Author Share Posted August 4, 2015 lol...yah, that was easy!!!! UPDATE phpbb_users SET user_id = (user_id + 8447001) Link to comment https://forums.phpfreaks.com/topic/297611-update-mysql-data-with-some-math-using-phpmyadmin/#findComment-1517960 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.