|
tech_1
Posting Yak Master
105 Posts |
 Posted - 01/06/2013 : 22:07:13
|
I have a table:
ID
SettingName
SettingValue (tinyint)
What I want, is to automatically increment SettingValue to the next logical bitwise value, if that makes sense? i.e: 1, 2, 4, 8, 16 etc...
is this possible to do somehow even if it is using triggers of some kind on the insert?
Thank you. |
|
|
tech_1
Posting Yak Master
105 Posts |
Posted - 01/06/2013 : 22:34:08
|
ok so I got that done by creating a TRIGGER on insert.
But now, what is a record in that table is updated?
I want to see if they changed a certain columns' value and if so, to roll it back so it goes back to the original value before the update.
thoughts? |
 |
|
Auto increase column on insert by x amount?
