[mythtv] DVB support - Status update

[Andy Davidoff]

That example uses an extra copy of the table for each additional
field you wish to include in the final results.  You'd have to know
how many attributes existed and their order and craft the query
appropriately.

Do you really think this is more elegant than just using a separate
table that is structured to hold each of the extra variables?  We'd
get the benefits of fixed-length records, data-types designed for the
data the column is storing, indices on specific attributes...

Take a look at the SQL I wrote to improve the queries for programs
plus recordings in MythWeb/functions.php -- it demonstrates the
kind of ugliness that can arise from shoehorning one-to-many into
one-to-one.


On May 02, at 20:06, Joel Feenstra encoded a 1.2K recording:
> I think your best bet is looking at the mysql section on join.
>
> http://www.mysql.com/doc/en/JOIN.html
>
> there's a user comment about student's grades and assignments that
> might be some help.