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
