• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB-Column Edit
#5
Thank you, Mike.

It took me some time to recognize that I have to make the two queries step by step, but something went wrong.

As I did not use commas to separate keywords, I first tried the two simple queries. But they created genres for nearly all songs with incredible many genres (see picture attached).
So I replaced the database by my backup and tried the more complex queries.

The complex queries created more new genres (from 46 to 101) including one "<blank>" genre.
Several genres got doubled "Med.", "Med." on songs.
A Song with the keyword "Bright Latin or Swing" at the end had the following genres:
"Bright", "BrighT", "Bright Latin", "Bright Latin or Swing", "Latin", "Swing", "<Blank>"

So the query created from every word (instead of "or") and every combination a genre and added this to the song.
I am not used with SQL so I don't know how to modify the query.

If everything would work well it would be good to have an additional query to delete all "keywords". I think that is easy for you unfortunaly not for me.

Thank you
Paul


Attached Files Thumbnail(s)
   
---------------------------------------------------------
13" - Point of View POV_TAB-P1325, Android 4.1.1
13" - Point of View POV_TAB-I1345, Android 5.1.1
Microsoft Surface Pro 4; Windows 10
Phone: Motorola Moto G3, Android 6.0
Reply


Messages In This Thread
DB-Column Edit - by Vibraphon - 07-13-2016, 05:49 PM
RE: DB-Column Edit - by Zubersoft - 07-14-2016, 02:01 AM
RE: DB-Column Edit - by Vibraphon - 07-18-2016, 03:40 AM
RE: DB-Column Edit - by Zubersoft - 07-18-2016, 06:50 PM
RE: DB-Column Edit - by Vibraphon - 07-21-2016, 03:30 AM
RE: DB-Column Edit - by Zubersoft - 07-21-2016, 08:19 AM
RE: DB-Column Edit - by Vibraphon - 08-09-2016, 11:33 PM



Users browsing this thread:
2 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.