Update MySQL data with some math, using phpMyAdmin.

[strago]

php 5.5.42

Database name: forums
Table name: phpbb_users
Row 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?

[requinix]

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.

[strago]

lol...yah, that was easy!!!!

 

UPDATE phpbb_users SET user_id = (user_id + 8447001)