Re: mySQL Autoincrement Field

mike cullerton schrieb am Freitag, 3. August 2001, 05:43:22: > on 8/2/01 9:01 PM, Ralph Guzman at raguzman@netraiser.com wrote: >> In mySQL, how do I set an auto increment field to start at a certain >> number-let's say 10000? Do I just insert the first record with the desired >> number I wish to start with? >> > it appears to depend on the table type. i believe you are ok with MyISAM or > InnoDB tables. check out the docs on table creation and column types at > mysql.com. Also, don't get confused on the use of auto increment fields. They are not meant to be counters. If you need a counter, define one separately. auto increment fields have a very specific meaning to table design and should be used only in this context. -- Herzlich Werner Stuerenburg _________________________________________________ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de