-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Saturday 19 July 2003 17:17, Andrew Rothwell wrote:
> So I can add the column, and I can set it to have an auto_increment, but
> will that start out at 201? or will it start at 1 and propogate through?
If you don't modify the table definition, it will start at 1 and propagate
throughout: e.g.
Alter Table X Add Fld int not null Primary Key Auto_Increment;
If you want it to start at another number, then you can tell the table to
start this way as follows:
Alter Table X Auto_Increment = 201;
Alter Table X Add Fld int not null Primary Key Auto_Increment;
In this case, the field would start numbering at 201 and continue throughout.
- ---Michael
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
iD8DBQE/Gcf+jeziQOokQnARAlxTAJ4q9Wj3LpentsdQ8y+fux+wRK7m/wCfaiac
ZypuuPoHG48ZBloVZT8+ChY=
=SP9C
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
