[mythtv-users] Help w/DB error with mythrename since adding .avi's into Recordings

[Bobby Gill]

>
> It depends on which field you'd like to update.  For example, you
> mention that you want all records with chanid='44' to be changed to
> chanid='1042'.  That query would be:
>
> mysql> UPDATE recorded SET chanid='1042' WHERE chanid='44';
>
> This will change ALL chanid fields to '1042' where the were '44'.
> More information on SQL can be found here:
> http://dev.mysql.com/doc/refman/5.1/en/index.html
>
> Enjoy!
>
> --
>

Thanks a ton Joe, I ran into a couple other errors in the DB and fixed 'em
up too, learning pretty fast ;) Thanks for the link as well, time to shape
up on my MySQL...

Thanks
Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090923/be5c192a/attachment.htm>