Let’s just say I have a table called TABLE_NAME
that looks like this:
x
id | name | changeme
------------------------
1 | One | 1
2 | Two | 0
3 | Three | 1
4 | Four | 0
5 | Five | 0
Is there an SQL statement I can run on this to change every changeme
entry to ‘0’?
Advertisement
Answer
do you mean?
UPDATE TABLE_NAME SET changeme = 0