#MYSQL DATA GENERATOR LICENSE#

But there is a nice one: RAND(N) itself!Ī sequence of random numbers created by the same seed is guaranteed to be.

Hash has been suggested by AES-encrypt fits also.

So using a uniqueness-preserving, pseudo-random transformation would be fine: Non-random uniqueness can trivially be achieved with AUTO_INCREMENT. This brings us to concentrate on the uniqueness first. While randomness is quite easily achieved, the uniqueness without a retry loop is not. This problem consists of two very different sub-problems: I've been able to generate strings by defining a string containing all the allowed chars and randomly substringing it, and nothing more. I thought of the generate&check loop approach again, but I'm not limiting this question to that just in case there's a more efficient one. The query I need should simply generate a 8-character alphanumeric string which is not already in the table. Therefore, I decided to try and solve this issue using a MySQL query. However, as the number of vehicles increases, I expect this to become even more inefficient it is right now. How I achieved this was using a while loop in Lua, which is the language I'm programming in, to generate strings and query the DB to see if it is used.

#MYSQL DATA GENERATOR LICENSE#

I need to find an unused license plate before creating a new vehicle - it should be an alphanumeric 8-char random string. Now here comes the part I'm having problems with.

I have a MySQL table named 'vehicles' containing the data about the vehicles, including the column 'plate' which stores the License Plates for the vehicles. I'm working on a game which involves vehicles at some point.

Mysql data generator