How to save unique alphanumeric content in MySQL?

Question

for example 100-character long

Answer 1

Mabe use UUID's http://en.wikipedia.org/wiki/Universally_Unique_Identifier

mysql> select uuid();
+--------------------------------------+
| uuid() |
+--------------------------------------+
| 3aee88e2-a981-1027-a396-84f02afe7c70 |
+--------------------------------------+
1 row in set (0.30 sec) 

Answer 2

1. Define a column in a table to be VARCHAR(100)
2. Make the column either the primary key or place a unique constraint on the column

Answer 3

I just answered this question for someone else, maybe an hour ago:

http://stackoverflow.com/questions/2380337/how-to-generate-unique-alphanumeric-content-in-mysql/2380357#2380357

Answer 4

You can use the uuid generator as indicated by clyfe.

To store, the best discussion can be found at http://forums.mysql.com/read.php?98,49626,49626#msg-49626

unfortunately u need to jump through a few simple hoops to get this done.