[mythtv-users] channel id change to mysql

[Ismo Tanskanen]

Thanks for helping.

I worked it out using temporary table.

I created table "chmov", made two columns there (old and new) and put
old and new chanid values there.
Then I executed this query for all required tables:

UPDATE recorded,chmov SET recorded.chanid=chanmov.new WHERE
recorded.chanid=chanmov.old

I made it using 10 query instead of 230.. great!

-kane