on 8/2/01 9:01 PM, Ralph Guzman at [EMAIL PROTECTED] 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. -- mike cullerton -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]