for my application i need to increment a value (preferably BIGINT) on each read-access (no Primary Key!).
Update after Select is not a nice solution as i have many instances of the user gathering this value in a cluster and the instances are not allowed to have the same value.
I had a look at UDF but couldn't yet figure out how to write back to the table in a function. I also tried AUTO_INCREMENT which should work as MySQL Manual says (increment on INSERT/UPDATE) with a dummy column to be update-trigger for my value-column, but this didn't work too...

Any hints/ideas are very welcome as this is my very last problem in the whole application.

btw. i'm using mysql 3.23.47 (but can upgrade if this should be neccessary)

Thnx in advance,