What language are you using? In PHP use this:
http://www.php.net/manual/en/function.session-id.php
You could also experiment with mySQL's built in
NOW or CURRENT_TIMESTAMP or UNIX_TIMESTAMP
or ENCRYPT or MD5 or SHA or AES_ENCRYPT
or RAND
And some combination of those (hint hint)
> -----Original Message-----
> From: DIetrich Speer [mailto:dspeer@stripped]
> Sent: Sunday, January 19, 2003 6:26 PM
> To: Mysql@stripped
> Subject: Random ID creation in MySQL /Linux
>
>
> Hello:
> I am trying to find a way to create a random ID for use as a
> session ID in a
> MySQL table.
> In MS SQL I use NewID(). Does anybody know an equivalent to
> use for MySQL,
> running on RedHat Linux 8.0?
>
> I'd be greatful for any tip.