When you create the table I think you just set it.. ie- create table blah.... AUTO_INCREMENT=9999
P -----"Scott Purcell" <[EMAIL PROTECTED]> wrote: ----- To: <[EMAIL PROTECTED]> From: "Scott Purcell" <[EMAIL PROTECTED]> Date: 02/09/2004 12:21PM Subject: auto_increment pseudo sequence? Hello, I have an application in which I am using auto_increment as a kind of sequence replacement. The only problem I have is trying to get the auto_increment to start at a larger number than 0. Is auto_increment the replacement for sequences? and if so, is there a way to set the digit to a larger number when creating? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]