i want to generate a unique primary key, something similar to the auto increment feature, but i do not want it to be auto increment.
The reasoning for this is: this table will have rows deleted by the hundreds every day, and maybe even thousands in a few years (I hope!), All the while having more rows replace the ones that were erased. Is there a way to have mysql create a unique key that is just randomly generated?
Thanks in advance!