在MySQL中创建短唯一ID的最佳方法

Question

I need to create unique IDs in MySQL for a php application. I what the IDs to be about 7 chars max, the only think i can think of doing is to used the uid that is created but i would like to create a random string rather than just 0000123 etc... i would prefer AB738DD or somthing of the like.

The other thing i thought of was using php to generate an id then check the db to see if it is already there, and if there isnt a match insert with that id, the only problem is i think that will create unneeded load on the mysql server and extra queries.

Has anyone else got any other ideas?

Thanks

Answer 1

One solution would be to store an integer but convert the value to hex on display. (Obviously this won't be random, but it wouldn't be all digits either).