Skip to content

Instantly share code, notes, and snippets.

@kramerc

kramerc/rekordbox6_path_replace.sql

Last active December 20, 2023 23:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kramerc/59d6a72a3a722ffb19255b63be105177 to your computer and use it in GitHub Desktop.
Save kramerc/59d6a72a3a722ffb19255b63be105177 to your computer and use it in GitHub Desktop.
Download ZIP
Query to update paths in a rekordbox 6 library
Raw
rekordbox6_path_replace.sql
update
djmdContent
set
FolderPath = b.FolderPath
from
(
select
id,
replace(FolderPath, 'M:', 'E:') as FolderPath
from
djmdContent
) b
where
djmdContent.id = b.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment