RE: quick mysql question
- From: Alex Hall <mehgcap@xxxxxxx>
- To: programmingblind@xxxxxxxxxxxxx
- Date: Wed, 08 Apr 2009 07:47:14 -0400
Yes, exactly!
Have a great day,
Alex
----- Original Message -----
From: "Juan Hernandez" <blindmagik@xxxxxxxxx
To: <programmingblind@xxxxxxxxxxxxx
Date sent: Tue, 7 Apr 2009 21:23:23 -0700
Subject: RE: quick mysql question
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
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
