[mythtv-users] Re: MythTV CVS & DataDirect - Success!

[Mike Jasper]

On 5/26/2004 11:40 AM, Robert Kulagowski wrote:

>> Yeah, this is weird.  It won't work for me, either, but the UPDATE 
>> syntax is correct, according to the mysql docs.  I get the following 
>> error:
>>
>> mysql> UPDATE channel,channel_copy SET channel.icon=channel_copy.icon 
>> WHERE channel.callsign=channel_copy.callsign;
>>
>> ERROR 1064: You have an error in your SQL syntax near 'channel_copy 
>> SET channel.icon=channel_copy.icon WHERE channel.callsign=channel_c' 
>> at line 1
>>
>> Anyone have success with this?
> 
> 
> You'll have more success if you use the appropriate commands for your 
> mysql version.  If you're not running MySQL v4, then don't use the 
> one-line version.  Check the HOWTO.

Right, that works.  Those directions weren't in the HOWTO when I was 
previously trying this.  Thanks.