I have a MYSQL table called traceclasses and I have a column in this table called value
with some of its cell values equal to E as shown below. I would like to replace all such values with U. Which query should I use to do this?
Advertisement
Answer
You are looking for update
:
x
update t
set value = 'U'
where value = 'E';