Auto_increment

[overlrd89]

Hi, I'm looking for some basic help. I am developing a MySQL database and want to auto increment a field, but I don't want it to just count 1,2,3, etc. I want the field to be a combination of letters and numbers, at least 8 digits long, completely random for security porposes, but do this automatically, everytime a record is added. Does anyone know how to do this?

[nicc777]

mysql> SELECT MD5( NOW() );
+----------------------------------+
| MD5( NOW() )                     |
+----------------------------------+
| fd2b7da27109302999758dabeaf6480c |
+----------------------------------+
1 row in set (0.15 sec)