Hello,

I have a database on mysql server that i was able to switch to. how would i change information in a certain table column?

Database Name: db_1
Table Name: config
Column Name: column 3

column 3 has a value of no, i would like it to say yes

what would be the correct MySQL syntax?

mysql> use db_1
mysql> update config set column_3 = 'yes' where column_3 = 'no';


Is there more than one row for this column 3 and is there a space or not? The above syntac will work if there's just that one row but if you have more than one row, it's going to update all of them, unless you specify anything unique about that row you want updated. Also if this is the only row for column 3, you can disregard the where clause after 'yes', just add the ; at the end.

You should read the mysql documentation though, these are very basic commands to know when administering a MySQL database.

thanks much! worked perfectly but just in case, how would i change it if i did have multiple rows?

Usually a row has something unique about it, say it had an ID column as well that was incremented and this one you wanted to update with ID = 50, you would do:


mysql> use db_1
mysql> update config set column_3 = 'yes' where ID = 50;

thanks very much!