[sqlite] how to re_update the id item

[YAN HONG YE]

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@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users