wOnKo's
Music Database
Primitive
PHP Query Engine
The MUSIC DATABASE is a simple
3-table relational database:
 |
The
ALBUMS table contains general information about the recordings (one
row per album) |
| |
|
 |
The
TRACKS table contains the song listings found on these recordings.
Disk number (for multi-disk sets) and the song titles found on those disks. |
| |
|
 |
The
PERFORMERS table contains information on what artist played what
instrument on the album. |
Enter your Query in the
text box below and submit it for processing - your answer table will be delivered
back to you if your query was error free.
MySQL language does not
yet allow Sub-Queries. Normal syntax for other types of queries should work
fine otherwise. In many cases it is possible to translate a sub-query into a
corresponding join (or left outer join) query.
|
