[mythtv-users] Re: MythTV CVS & DataDirect - Success!
Jarod C. Wilson
jcw at wilsonet.com
Thu May 27 01:02:27 EDT 2004
On May 26, 2004, at 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.
Yeah, it wasn't there yet when I was trying, but I found it. Works like
a charm for MySQL 3.x.
--
Jarod C. Wilson, RHCE
Got a question? Read this first...
http://catb.org/~esr/faqs/smart-questions.html
MythTV, Fedora Core & ATrpms documentation:
http://wilsonet.com/mythtv/
MythTV Searchable Mailing List Archive
http://www.gossamer-threads.com/lists/mythtv/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20040526/533cdc5a/PGP.pgp
More information about the mythtv-users
mailing list