[mythtv-users] Switching to DataDirect

James Pifer jep at obrien-pifer.com
Tue May 25 14:35:49 EDT 2004


On Tue, 2004-05-25 at 14:16, Robert Kulagowski wrote:
> 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.
> 
> ______________________________________________________________________
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Thanks, that was it. 

James



More information about the mythtv-users mailing list