From: Daevid Vincent
Date: January 20 2003 2:50am
Subject: RE: Random ID creation in MySQL /Linux
List-Archive: http://lists.mysql.com/mysql/130375
Message-Id: <000801c2c02e$a79b8110$0801a8c0@telecom>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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.