Re: quick mysql question
- From: "R. Haynie" <rhaynie@xxxxxxxxxxx>
- To: programmingblind@xxxxxxxxxxxxx
- Date: Tue, 07 Apr 2009 22:51:24 -0400
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
Other related posts:
