On 11/10/2013 8:12 PM, David M. Cotter wrote:
what i did before SQL was to just tell the new song (which may have updated / corrected
meta data) to have the old song ID (and tell the old one to have the new one), then i'd
just delete all the "new" song ids (since they had been swapped, i'd be really
deleting all the old songs).
so, can i do this with SQLite?
You can INSERT and UPDATE primary key fields the same way you can any
other field - subject to uniqueness constraint, of course (at no point
in time could there be two records with the same key, no matter how this
key was arrived at).
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users