Page 1 of 1
SQL Editor: where is the documentation? Table names? What to query?
Posted: Sat Jul 01, 2023 7:12 am
by YetAnotherLondonder
I have installed the SQL Editor addon.
Where is the documentation? What is the database scheme? What tables are there and how are they linked
Playing around a bit, I noticed I can run something like
Code: Select all
select * from songs where artist ='Queen'
but, still, the questions remains: what is the database scheme? How are we supposed to know what to query?
Re: SQL Editor: where is the documentation? Table names? What to query?
Posted: Sat Jul 01, 2023 10:06 am
by dtsig
did you do a search on Sql Scheme? I know there are articles out there about it as I asked this question 3-4 years ago and got a response. THere is an article in the on line help wiki.
Re: SQL Editor: where is the documentation? Table names? What to query?
Posted: Sat Jul 01, 2023 3:53 pm
by YetAnotherLondonder
Searching the forum for "SQL schema" doesn't give me any results. The 3 links you posted don't work
Re: SQL Editor: where is the documentation? Table names? What to query?
Posted: Sat Jul 01, 2023 4:55 pm
by dtsig
went to the wiki and did a search on database structure and got this ...
https://www.mediamonkey.com/wiki/Databa ... ture_(MM4)
Re: SQL Editor: where is the documentation? Table names? What to query?
Posted: Sat Jul 01, 2023 5:13 pm
by YetAnotherLondonder
Thanks!