assisning random number to database

[london]

hi forum buddies

I have a list of email addresses in a text file.

I want to create a table and have them added to a new table with 3 columns/fields - ID, Email, and UID

ID - Integer - auto increment
Email - varchar 40
UID - Unique random value 15 characters (varchar)

How do I get the UID added such that it is random and unique.
Will i be able to do this?? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[villers]

Hi

Yup, use the UUID() function

you'll want to take a substring out of it somewhere

you may want a unique constraint in your UID column to be sure it's unique.


Cheers -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[acerman]

Ditto, he is absolutely right -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --