At 2:58 PM -0800 12/21/00, Jason Bell wrote:
>add DEFAULT 'value' into your column string..... should work.....
Actually, you specify it when you create the table:
CREATE TABLE tbl_name ( column definitions ) AUTO_INCREMENT = initial_number
See:
http://www.mysql.com/documentation/mysql/commented/?section=CREATE_TABLE
>Jason
>
>----- Original Message -----
>From: "Scott Gerhardt" <scott@stripped>
>To: "Mysql" <mysql@stripped>
>Sent: Thursday, December 21, 2000 2:52 PM
>Subject: Setting derault for auto_increment
>
>
>> I'm adding an AUTO_INCREMENT column to a table and would like to set the
>> starting number.
>> What is the easy way to do this?
>> Can't seem to find the answer in the online docs.
>> I can't seem to set the default using auto_increment=999 etc.
>>
>> I guess a work-around would be to insert a dummy row into the table with
>the
>> value I want, set the column to auto_increment and then remove the dummy
>> row, but this seems like extra work.
>>
>> - Scott
>>
>>
>> ___________________________________
>>
>> Scott A. Gerhardt P.Geo.
>> Gerhardt Information Technologies
>> scott@stripped
>> ___________________________________
>>
>>
>>
>> --
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/documentation/manual.php" before
>> posting. To request this thread, e-mail mysql-thread59756@stripped
>>
>> To unsubscribe, send a message to:
>> <mysql-unsubscribe-jbell=barkingrat.com@stripped>
>>
>> If you have a broken mail client that cannot send a message to
>> the above address (Microsoft Outlook), you can use:
>> http://lists.mysql.com/php/unsubscribe.php
>>
>>
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php" before
>posting. To request this thread, e-mail mysql-thread59758@stripped
>
>To unsubscribe, send a message to:
> <mysql-unsubscribe-paul=snake.net@stripped>
>
>If you have a broken mail client that cannot send a message to
>the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
--
Paul DuBois, paul@stripped
