Auto_Increment at Random?

[James Maxon]

Hi, I’m using the MySQL Control Panel 0.9.4. I can do this with SQL so I assume MySQL can as well?:

I want to have a user fill out a form on my site, then when their information is inserted into the database I want it to automatically generate the User ID #. I went ahead and set this up and checked, “Auto_Increment”. And it works. The only problem is that it increases the increment by 1 each time. I have a Length of 11 and want it to randomly mix up all the numbers. I want to avoid a member changing the 1 increment to access someone else’s account. Is there a way to have the number generate at random rather than by 1 increment at a time in MySQL?

Thanks-James