[mythtv] Problem with DataDirect Migration docs

[Dan Morphis]

That won't work in mysql3.  MySQL3 doesn't support sub-selects :(

-dan

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
>  
>