unique random alphanumeric in MySQL

[Jassim Rahma]

hi, I want to know how can I created a unique random alphanumeric PIN in MySQL? I have job_order_code field and I want everytime to set a unique random alphanumeric code? Thanks.

Technology News @ www.JassimRahma.com

[thatraja]

Googled? MySql also has RAND[^] function, using that you could generate random things. Do customize.

thatraja

Please update this article Useful Reference Books, it's urgent for Q/A section

[jschell]

Jassim Rahma wrote:

unique random alphanumeric PIN

Why does it need to be unique?

[Jassim Rahma]

because it's a reservation code

Technology News @ www.JassimRahma.com