Re: create table

[Randy Elliott]

Thanks for the update. I spent a lot of time there yesterday morning. We just downloaded mysql Monday morning.

Evidently I am missing something. Here is my create table:

CREATE TABLE TEST.LdgrMaster
( LD_ACCTID char (10) NOT NULL
,LD_DTEKEYED_YMD char (8) NOT NULL
,LD_LEDCTR char (5) NOT NULL
,LD_AGNT char (4) NULL
,LD_TIME char (4) NULL

PRIMARY KEY LD_ACCTID ,LD_DTEKEYED_YMD ,LD_LEDCTR) TYPE=MYISAM;

Here is my error message.

mysql> source createldgrtable.sql
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'LD_ACCTID ,L
D_DTEKEYED_YMD ,LD_LEDCTR) TYPE=MYISAM' at line 8
mysql>

Any help would be greatly appreciated.

Randy