List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:September 24 1999 6:12pm
Subject:Re: Adding a record number field
View as plain text  
At 12:45 PM -0500 9/24/99, Carl Schrader wrote:
>Alok,
>
>Ok, but how can I add the numbers to the existing fields?

You'll have to do it manually.  If you haven't put anything in the
field yet, delete it, and then re-add it as an AUTO_INCREMENT
field and MySQL will number if for you automatically.  No work
involved.

>
>Alok singh wrote:
>
>> Carl Schrader wrote:
>>
>> > I have added a new column to an existing database. I would like to
>> > assign a unique number to each row. Row 1 would be 1, Row 2 = 2.. etc.
>> > Is there an easy way to add these numbers to the field?
>> >
>> > ---------------------------------------------------------------------
>> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>> > posting. To request this thread, e-mail win32-thread595@stripped
>> >
>> > To unsubscribe, send a message to the address shown in the
>> > List-Unsubscribe header of this message. If you cannot see it,
>> > e-mail win32-unsubscribe@stripped instead.
>>
>>   Hi,
>>     Use AUTO INCREMENT on the column when creating the the table
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread597@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail win32-unsubscribe@stripped instead.


--
Paul DuBois, paul@stripped
Thread
Adding a record number fieldCarl Schrader24 Sep
  • Re: Adding a record number fieldAlok singh24 Sep
  • Re: Adding a record number fieldCarl Schrader24 Sep
    • Re: Adding a record number fieldPaul DuBois24 Sep
  • Re: Adding a record number fieldBob Kline24 Sep