RE: quick mysql question
- From: "Juan Hernandez" <blindmagik@xxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Tue, 7 Apr 2009 21:23:23 -0700
So you want mysql to keep thhe ids continuious? So if you have records
1,2,3,4, and you delete record 2, you want it to be changed to 1,2,3? Not
1,3.,4?
Thanks.
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Alex Hall
Sent: Tuesday, April 07, 2009 8:22 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Re: quick mysql question
Okay, so the numbering is lost if you delete. Is there a more robust way of
numbering, so that you would have gotten:
1, abc'
2, 'ghi'
3, 'kno'
instead? I need the index of each record to always be sequential so that I
can know how many total records there are and also know which ones I have
used in the displaying of all of them.
Have a great day,
Alex
> ----- Original Message -----
>From: "R. Haynie" <rhaynie@xxxxxxxxxxx
>To: programmingblind@xxxxxxxxxxxxx
>Date sent: Tue, 07 Apr 2009 22:51:24 -0400
>Subject: Re: quick mysql question
>An example is worth a thousand words...
>create table tbl1 (fld1 INTEGER AUTO_INCREMENT,
>fld2 char(3),
>PRIMARY KEY (fld1));
>insert into tbl1 (fld2) values ('abc'), ('def'), ('ghi'),
('jkl');
>select * from tbl1;
>-- gives you:
>1, 'abc'
>2, 'def'
>3, 'ghi'
>4, 'jkl'
>delete from tbl1 where fld1 in (2, 4);
>insert into tbl1 (fld2) values ('mno'); select * from tbl1;
>-- gives you:
>1, 'abc'
>3, 'ghi'
>5, 'mno'
>HTH.
>-Rodney
>Alex Hall wrote:
>> Hi all,
>> If I have a table of records and one column is an autoincrement,
what
>> happens when I delete a record? I want to use the autoincrement
as an
>> index, so records 1, 2, 3, and 4 exist where 1-4 are the indexes
of
>> the records, If you delete record 3, do you then have records 1,
2,
>> and 3, or 1, 2, and 4? If it is the second case, is there a
better way
>> to have an index of each record? I need to know how many
recordsI am
>> using on a page (it is sort of a photo viewer so I need to know
which
>> pictures are being shown and how many more there are) and how
many
>> total there are to go. Thanks.
>> Have a great day,
>> Alex
>> __________
>> View the list's information and change your settings at
>> //www.freelists.org/list/programmingblind
>__________
>View the list's information and change your settings at
>//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
