[mythtv] Problem with DataDirect Migration docs

[Joseph A. Caputo]

On Tuesday 18 May 2004 17:59, 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.

I've been away on vacation & am just sifting through the backlog of mail 
in digest form, so sorry if this has already been answered (I can't see 
the thread view).

I'm running MySQL 3 on FC 1, just upgraded to DataDirect last night.  
The query quoted above doesn't work for me.  Unfortunately the error 
message is not very helpful.  Here's the output (I spread it over a 
bunch of lines to try and localize the error):

mysql> update channel
    -> set icon =
    -> (select distinct icon
    -> from channel_copy
    -> where channel.callsign =
    -> channel_copy.callsign);
ERROR 1064: You have an error in your SQL syntax near 'select distinct 
icon
from channel_copy
where channel.callsign =
channel_copy.ca' at line 3


-JAC