On Wed, May 23, 2001 at 02:22:02PM -0400, Dave Carter spake thusly:
*] I need to generate a RANDOM UNIQUE number for every new record. Is there an
*] easy way to accomplish this inside of mySQL.
*] 

The way I do this for session ids is through a perl function that I 
wrote a long time ago.  Essentially I create a really long string of 
mixed case alpha characters and numeric digits. 

I suppose you could use the same method from perl for record "numbers."


-- 
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Peter L. Berghold                        [EMAIL PROTECTED]
Schooner Technology Consulting           http://www.berghold.net
Unix Professional Services    Perl Perl/CGI mod_perl 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to