I have to insert a simply button that update all values with number ‘1’.
Why I have this error trying to execute that API?
It’s possible to make an update without ‘where’ condition?
Something like that:
UPDATE table_name
SET column1 = value1
Just make the WHERE the id column is not null - that will include all rows anyway
1 Like