Re: [sqlite] Can i change the primary key?

2013-11-13 Thread David M. Cotter
ah! this was my answer! thanks! On Nov 11, 2013, at 6:03 AM, Igor Tandetnik 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 >>

Re: [sqlite] Can i change the primary key?

2013-11-11 Thread Igor Tandetnik
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 r

[sqlite] Can i change the primary key?

2013-11-11 Thread David M. Cotter
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