I need to create a script to run on a MySQL server to update the country column in a bunch of rows. I have a list of what users need to have their country updating, but surely there's a way to input this list and have a script process it? I'm fairly new to MySQL and don't touch it very often.
The rows are in jos_users and each row has a column called 'country'. Is there any way for me to provide a MySQL script with a list of users, and have it update the country column for all of the users in the list(there'll only be one country for all of the users). My only experience with scripting for MySQL is with PHP and reading from the database.
Thanks.
The rows are in jos_users and each row has a column called 'country'. Is there any way for me to provide a MySQL script with a list of users, and have it update the country column for all of the users in the list(there'll only be one country for all of the users). My only experience with scripting for MySQL is with PHP and reading from the database.
Thanks.
Last edited: