i've got say a music database the unique "song ID" is the "integer primary key", used to look up the song and all it's data
sometimes an update of the meta data comes along, so i want to update to the new list, but preserve the old song IDs (so playlists that refer to them still link up) 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? it was efficient because i could simply swap ONE integer between these records. or, must i instead keep the song IDs the same, and swap all the other data? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users