List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 24 2000 6:15pm
Subject:Re: column numbering
View as plain text  
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
Thread
column numberingGary23 Oct
  • Re: column numberingRolf Hopkins24 Oct
  • Re: column numberingGary24 Oct
    • Re: column numberingPaul DuBois24 Oct
  • Re: column numberingRolf Hopkins24 Oct
  • Re: column numberingGary24 Oct