Quick mysql question

[Logic]

I'm no MySQL wiz so I'm unsure what to use. But I'm needing a query that will change all the 0's under the home_room column to 14, all at once for everyone. The table will be `users` and the column is `home_room`.

Thanks!

 

[Fisher]

UPDATE users SET home_room = '14'

Run that query, that will however, only change the users currently in the database. Any new players you get will still have the default 0.
If you are using NaviCat to manage your database go to your users table, click file >> design and set the default home_room as 14, that will make it so all new players are set to 14. Then run the query to change the existing users.

 

[Logic]

Already got this, thanks.