[mythtv-users] Switching to DataDirect

[Mike J. Harrison]

You need to specify a column for the table, which the "CREATE TABLE
channel_copy SELECT * FROM channel;" does for you.

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of James Pifer
Sent: Tuesday, May 25, 2004 11:48 AM
To: MythTV
Subject: [mythtv-users] Switching to DataDirect


I'm trying to convert to DataDirect for channel data. I'm following the
howto in the docs from the CVS tarball. I'm getting this:

mysql> create table channel_temp;
ERROR 1113: A table must have at least 1 column
mysql> 

As far as I can tell I'm running mysql 3:
[root at mythtv /]# rpm -qa mysql
mysql-3.23.58-1.9

Anyone know what the problem is? Didn't see this in the archives. 

Thanks,
James