Re: [sqlite] how to re_update the id item

On 3 Sep 2012, at 7:53am, YAN HONG YE wrote: > my database have a column named id auto_increament inter primary key, when I > delete any rows , the id item may be indiscriminate , how to update it and > reorder the > column from 1 to max(id) order by id asc? Can you think through why you're

Re: [sqlite] how to re_update the id item

YAN HONG YE wrote: > my database have a column named id auto_increament inter primary key, when I > delete any rows , the id item may be indiscriminate > , how to update it and reorder the column from 1 to max(id) order by id asc? It's not quite clear what you are trying to achieve. Perhaps som

[sqlite] how to re_update the id item

my database have a column named id auto_increament inter primary key, when I delete any rows , the id item may be indiscriminate , how to update it and reorder the column from 1 to max(id) order by id asc? ___ sqlite-users mailing list sqlite-users@sq