[mythtv-users] renumber channels

Stephen Worthington stephen_agent at jsw.gen.nz
Sun May 11 23:45:14 UTC 2014


On Sun, 11 May 2014 12:40:01 -0600, you wrote:

>I found this update channel set channum = channum + 10000 where sourceid in
>('4','5','6');
>now how i get list of sourceids corresponding to source name
>I am using workbench to explore table but is not very clear

select sourceid,name from videosource order by sourceid;


More information about the mythtv-users mailing list