List:MySQL and Java« Previous MessageNext Message »
From:reid Date:May 19 2003 6:20pm
Subject:Re: delete data
View as plain text  
Thank for your input. Sorry if you get this second time.

Reid

----- Original Message ----- 
From: "Paul DuBois" <paul@stripped>
To: "reid" <reid@stripped>; <java@stripped>
Sent: Monday, May 19, 2003 10:20 AM
Subject: Re: delete data


> At 9:43 -0600 5/19/03, reid wrote:
> >When I delete the last line of tables and add new records and put in the
> >wrong place. For example I delete line 288 and add new data. It went to
line
> >289. Why is that? Do we need to refresh it or something?
>
> Tables don't have "lines".  What are you referring to?  If you're
> referring to the behavior of an AUTO_INCREMENT column, that's how it
> works (deleted values are not reused).
>
> The exception is for ISAM tables, which reuse deleted values if they are
> deleted from the top of the sequence.  But ISAM tables are deprecated.
>
> >Reid
>
>

Thread
Query flowFilip Rachunek19 May
  • delete datareid19 May
    • Re: delete dataPaul DuBois19 May
  • Re: delete dataChristopher Taylor19 May
  • Re: delete datareid19 May
  • sort ascendingreid19 May
  • installation mysqlreid22 May
    • Re: installation mysqlDave Newton23 May
Re: sort ascendingAndreas Schyman20 May