Update songs table

[ezryder007]

Hi,

I am loving media monkey 5 for finally organising of my media files.

Now I discover I can also use the database (with care!) I am even happier.

I want to run an update statement against the songs table and correct song title like this one:
"Galway Races;Galway Races"

I am using dbvisualiser against a backup of the database. But get the (no such collation sequence: IUNICODE) error.

Not sure if I can get round this in dbvisualiser but came across this very old thread:
viewtopic.php?t=66469

Is this extension still valid for use against v5 or has it been superceded?

Thanks,
Dan

[ezryder007]

In addition to the above question about the extension...

My current problem in a nutshell is the first of these commands works, but the second one doesn't. I can only summise there is something different about the songTitle field...

Code: Select all

update songs set TrackNumber = 'A Night To Remember' COLLATE BINARY where SongTitle = 'Around The World' COLLATE BINARY;

Code: Select all

update songs set SongTitle = 'A Night To Remember' COLLATE BINARY where SongTitle = 'A Night To Remember;A Night To Remember' COLLATE BINARY;

[ezryder007]

I answered my first question when I found this:

Compatibility
This add-on doesn't work with MediaMonkey v5! No add-on made for a previous version of the program will work with MM5, either by me or any other author, since MM5 has completely different programming interface than before. Which means that all MM4 add-ons have to be rewritten for MM5 from scratch.

So I have a greater emphasis on why one of my update statements does not work. Very interested if anyone has any ideas!

[Ludek]

Hi,
I don't know the dbvisualiser addon, but you can use this addon that is compatible:
https://www.mediamonkey.com/addons/brow ... ql-editor/

[ezryder007]

Fantastic!
Thanks. Seems to work fine with select statements. I'll carefully try an update statement.
Thanks,
Dan

[ezryder007]

This worked like a charm. Thanks.