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)