[mythtv] Problem with DataDirect Migration docs

[James Armstrong]

Robert Kulagowski wrote:

>> I haven't updated yet and don't know if this will work in mysql3, but 
>> this should work as long as there is a channel_copy table:
>>
>> update channel
>> set icon = (select distinct icon from channel_copy
>>             where channel.callsign = channel_copy.callsign);
>
>
> Has anyone still running MySQL 3 tried this and had it work correctly? 
> I'll include it if I get some feedback that this is doing the Right 
> Thing.
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-dev mailing list
>mythtv-dev at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>  
>
I just tried it. I get:
ERROR 1064: You have an error in your SQL syntax near 'select distinct 
icon from
 channel_copy where channel.callsign=channel_copy.calls' at line 1

- James

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20040519/a90669fe/attachment.htm