Setting default auto_increment start int

Hi All, Just a quick question: How do I set the auto increment for a field to start from an integer other than 1. For example, I would like to be able to have the auto increment counter start from 1000. Thanks, Javan.

Re: Setting default auto_increment start int

Javan B. [EMAIL PROTECTED] wrote: Just a quick question: How do I set the auto increment for a field to start from an integer other than 1. For example, I would like to be able to have the auto increment counter start from 1000. Use AUTO_INCREMENT option of CREATE TABLE statement:

RE: Setting default auto_increment start int

, 2003 3:50 AM To: [EMAIL PROTECTED] Subject: Re: Setting default auto_increment start int Javan B. [EMAIL PROTECTED] wrote: Just a quick question: How do I set the auto increment for a field to start from an integer other than 1. For example, I would like to be able to have