At 9:16 PM -0400 10-23-2000, Gary wrote:
>no, I am talking about renumbering after you delete a row. If I delete row 10
>then I would have 1,2,3,4,5,6,7,8,9,11,12, and so on. What I was wondering is
>there a way when you delete a row to get the table to renumber, so you would
>not have gaps in the numbers.
You could use ALTER TABLE, first to drop the column, then to add it back.
MySQL will automatically assign new sequence numbers.
>
>Gary
>
>Rolf Hopkins wrote:
>
>> If you are talking about an auto numbering column, the answer is stated in
>> the manual.
>>
>> myism tables - no, ism tables - yes.
>>
>> Or you could do it programmatically without the use of an auto numbering
>> column.
>>
>> ----- Original Message -----
>> From: "Gary" <deadfred@stripped>
>> To: <mysql@stripped>
>> Sent: Tuesday, October 24, 2000 0:55
>> Subject: column numbering
>>
>> > I am new to MySQL and have look in the manual for an answer to this. In
>> > a table, the first column is id. int(11), not null, primary key. When I
>> > delete a row form the table, it keeps numbering from the last number it
>> > used, and that's what i would expect it to do. Is there a way to get the
>> > table to reset the numbers when a row is deleted. I am using php to
>> > delete the rows.
>> >
>> > Thanks
>> > Gary
>> >
>> > --
>> > The sad thing about artificial intelligence is that it lacks artifice
>> > and therefore intelligence. Jean Baudrillard (1929), French semiologist.
>> >
>> >
>> >
>> >
>> > --
>> > ---------------------------------------------------------------------
>> > Please check "http://www.mysql.com/documentation/manual.php" before
>> > posting. To request this thread, e-mail mysql-thread53992@stripped
>> >
>> > To unsubscribe, send a message to:
>> > <mysql-unsubscribe-rhopkins=mail.waytech.com.tw@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
>
>--
>The sad thing about artificial intelligence is that it lacks artifice and
>therefore intelligence.Jean Baudrillard (1929), French semiologist.
>
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php" before
>posting. To request this thread, e-mail mysql-thread54056@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
