MySQL Forums
Forum List  »  Other Migration

Advanced Search
New Topic

Re: create table
Posted by: Randy Elliott
Date: July 21, 2004 09:02AM

I tried many combination of ( ) yesterday.
Just now I put a ) after the last null and before PRIMARY and put a ( in front of LD_ACCCTID.
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 'PRIMARY KEY
(LD_ACCTID ,LD_DTEKEYED_YMD ,LD_LEDCTR) TYPE=MYISAM
mysql>

Thanks
Randy

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
create table
5715
Randy Elliott
July 20, 2004 12:20PM
Re: create table
5120
Nick Roper
July 20, 2004 02:59PM
Re: create table
3125
Randy Elliott
July 21, 2004 08:34AM
Re: create table
2850
Nick Roper
July 21, 2004 08:52AM
Re: create table
3083
Randy Elliott
July 21, 2004 09:02AM
Re: create table
2940
Nick Roper
July 21, 2004 09:11AM
Re: create table
2817
Randy Elliott
July 21, 2004 09:26AM
Re: create table
2891
Nick Roper
July 21, 2004 09:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.