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

Reply via email to