<div>
You actually can control this behavior - but not at the CREATE TABLE level. &nbsp;You can set server parameters (auto_increment_increment and auto_increment_offset) that control this:<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html</a><br />
<br />
Obviously, this impacts all tables.<br />
<br />
Hope that helps.
</div>


You actually can control this behavior - but not at the CREATE TABLE level.  You can set server parameters (auto_increment_increment and auto_increment_offset) that control this:

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html [http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html]

Obviously, this impacts all tables.

Hope that helps.

<div>
<div class="content wysiwyg-content">
How can you specify the seed and step values when creating an autonumber using the create table command?<br />
<br />
Thanks<br />
<br />
Fred
</div>
</div>


How can you specify the seed and step values when creating an autonumber using the create table command?

Thanks

Fred

Specifying auto number seed and step values in MySql when using the Create Table command

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.