List:MySQL and Java« Previous MessageNext Message »
From:Paul DuBois Date:May 19 2003 4:20pm
Subject:Re: delete data
View as plain text  
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