All Questions
Tagged with random auto-increment
3 questions
9
votes
2
answers
18k
views
Randomizing the Auto Increment in Mysql
We have a database, where we insert data into table whenever we receive an order from our services.
We use auto_increment to generate the ID and assign the order with the same.
This is usually same ...
6
votes
4
answers
6k
views
Primary key with randomly varying increments (so it cannot be guessed easily)
I would like the primary keys to be auto-incremented and generated but in varying increments. For ex, if I have increment range as 100... then the auto generated keys would be something like below:
- ...
5
votes
1
answer
6k
views
How do I make MySQL auto increment in random order?
I have a table that contains several keys into other tables (where each key is comprised of multiple columns). I would like to create a new column for each key that would be an integer such that ...