On 1 Nov 2016, at 11:14am, Andy Ling <andy.l...@s-a-m.com> wrote: > MySQL lets you fiddle.....
I don't have MySQL. To satisfy my curiosity, could you try this: create table tt (id int NOT NULL AUTO_INCREMENT, v TEXT, PRIMARY KEY(id)) ; insert into tt (v) VALUES("one"); update tt set id=10 where v="one"; insert into tt (v) VALUES("two"); select * from tt; You got this far already (though I changed the details a little). Now add this: update tt set id=40 where v="two"; select * from tt; update tt set id=30 where v="two"; insert into tt (v) VALUES("three"); select * from tt; I'm trying to find out whether it remembers that there once was a value that was 40, even if the highest value present when you do the insert is 30. My guess is that it'll assign an id of 41 to row three, but I might be wrong. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users