ah! this was my answer! thanks! On Nov 11, 2013, at 6:03 AM, Igor Tandetnik <i...@tandetnik.org> wrote:
> 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). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
