Hi I am wanting to use auto incrementing numbers. Now I know that if I add an entry to the db then the number is auto assigned. Now what I want is it where I can get the next auto number and then add my entry using this number. The reason for this is that I need this number for a number of tables as it is the primary key. Now I know this is possible in Oracle and Postgress because you retrieve the next number and use it. When you retrieve the number it automatically increments so that the same number cannot be given out twice ie. concurrency issues. Is there a method in MySQl for doing this. Thanks Sean ~~~ Sean Preston [EMAIL PROTECTED] GNU/Linux, the OS of choice --------------------------------------------------------------------- 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