What language are you using? In PHP use this:
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
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
> 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.