[mythtv-users] Switching to DataDirect

Robert Kulagowski bob at smalltime.com
Tue May 25 14:16:34 EDT 2004


Yes, I think I screwed up when I pasted it.  Try:

mysql>create table channel_temp
select c.chanid, c.channum, c.sourceid, c.callsign, c.name, cb.icon,
c.finetune, c.videofilters, c.xmltvid, c.contrast, c.brightness,
c.colour, c.freqid, c.recpriority, c.hue, c.tvformat,
c.commfree, c.visible, c.outputfilters
from channel c
left join channel_copy cb on (c.callsign = cb.callsign);

Get rid of the semi after channel_temp so that the select is part of the 
create table command.


More information about the mythtv-users mailing list