hello, i hope some database guru can help me with this!
i need to set up an auto_increment field inside mysql. for various reasons, the maximum size is 3. but i don't want this to be ONLY integers because that limits me until 999 numbers only. since i have all flexibility for these three digits or letters, i want to include numbers and some characters into it as well. e.g., m78 23a 1pt 1~8 !76 ...etc can all be valid keys for me. how can i generate such numbers on the fly? if not inside mysql, then inside php? AND...be sure that the "key" so generated has not been used before as an id field in my data? any ideas would be very welcome! thanks very much in advance/erick __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com --------------------------------------------------------------------- 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
