SQL Editor: where is the documentation? Table names? What to query?

YetAnotherLondonder · Post by **YetAnotherLondonder** » Sat Jul 01, 2023 7:12 am

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?

dtsig · Post by **dtsig** » Sat Jul 01, 2023 10:06 am

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.

YetAnotherLondonder · Post by **YetAnotherLondonder** » Sat Jul 01, 2023 3:53 pm

Searching the forum for "SQL schema" doesn't give me any results. The 3 links you posted don't work

dtsig · Post by **dtsig** » Sat Jul 01, 2023 4:55 pm

went to the wiki and did a search on database structure and got this ... https://www.mediamonkey.com/wiki/Databa ... ture_(MM4)

YetAnotherLondonder · Post by **YetAnotherLondonder** » Sat Jul 01, 2023 5:13 pm

Thanks!

SQL Editor: where is the documentation? Table names? What to query?

SQL Editor: where is the documentation? Table names? What to query?

Re: SQL Editor: where is the documentation? Table names? What to query?

Re: SQL Editor: where is the documentation? Table names? What to query?

Re: SQL Editor: where is the documentation? Table names? What to query?

Re: SQL Editor: where is the documentation? Table names? What to query?