MySQL Forums
Forum List  »  Other Migration

Advanced Search
New Topic

Re: create table
Posted by: Nick Roper
Date: July 21, 2004 08:52AM

Hi Randy,

try:

CREATE TABLE TEST.LdgrMaster (

column definitions...

PRIMARY KEY (LD_ACCTID ,LD_DTEKEYED_YMD ,LD_LEDCTR)

) TYPE=MYISAM;

i.e. put the column list for the primary key in parentheses.

Nick

--
Nick Roper

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


Subject
Views
Written By
Posted
create table
5285
Randy Elliott
July 20, 2004 12:20PM
Re: create table
4877
Nick Roper
July 20, 2004 02:59PM
Re: create table
2928
Randy Elliott
July 21, 2004 08:34AM
Re: create table
2645
Nick Roper
July 21, 2004 08:52AM
Re: create table
2872
Randy Elliott
July 21, 2004 09:02AM
Re: create table
2741
Nick Roper
July 21, 2004 09:11AM
Re: create table
2636
Randy Elliott
July 21, 2004 09:26AM
Re: create table
2685
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.