How do I prevent updates on an entire table (but allow inserts) in Mysql 5.5?

Question

I want to make the rows in a Mysql table immutable, once they are inserted I don't want it to be possible to change them. How can I do this?

This question handles making individual rows immutable, but I'm hoping there is a better way to make all rows in a table immutable (ideally returning a suitable error message if any change is attempted).

score 4 · Answer 1 · answered Mar 10 '12 at 13:51

4

You can revoke 'UPDATE' privilege for a particular table. Or you can write BEFORE UPDATE trigger that raises an error (using signals or issuing a statement that always fails).

answered Mar 10 '12 at 13:51

a1ex07

9,060
3
27
41

How do I prevent updates on an entire table (but allow inserts) in Mysql 5.5?

1 Answers1

Linked