MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Richard Fox Date:July 11 2002 4:26pm
Subject:Re: auto-increment usage question
View as plain text  
But the default table type is already MyISAM

> That is the normal behavior for ISAM type files.
> Convert them to MYISAM.
>
> Richard Fox wrote:
>
> >>Hi,
> >>
> >>I have a mysql table which has a run_id which together with user_id
forms
> >>
> >the
> >
> >>primary key for the table. run_id is not null and auto-increment. I
delete
> >>records from this table, and add new records. I want the run_id to keep
> >>incrementing and not reuse values, but here is the actual behavior:
> >>
> >>    When records are deleted, upon the next insert run_id will be given
a
> >>value which is one higher than the greatest value remaining in the
table.
> >>
> >If
> >
> >>the table is empty, run_id will be assigned '1'.
> >>
> >>Is there any way in which I can get run_id to keep incrementing and not
be
> >>based on the current highest value in the table, but on the last
assigned
> >>run_id even if that record has been deleted?
> >>
> >>If not, are there any common workarounds?
> >>
> >>TIA
> >>
> >>Rich
> >>
> >
> >sql, query
> >
> >
> >---------------------------------------------------------------------
> >Before posting, please check:
> >   http://www.mysql.com/manual.php   (the manual)
> >   http://lists.mysql.com/           (the list archive)
> >
> >To request this thread, e-mail <mysql-thread114200@stripped>
> >To unsubscribe, e-mail
<mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread114207@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-rfox=sbsii.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
Re: auto-increment usage questionRichard Fox10 Jul
Re: auto-increment usage questionGerald Clark10 Jul
Re: auto-increment usage questionRichard Fox11 Jul
  • Re: Re: auto-increment usage questionVictoria Reznichenko12 Jul
Re: auto-increment usage questionGerald Clark12 Jul