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
5412
Randy Elliott
July 20, 2004 12:20PM
Re: create table
4972
Nick Roper
July 20, 2004 02:59PM
Re: create table
3002
Randy Elliott
July 21, 2004 08:34AM
Re: create table
2718
Nick Roper
July 21, 2004 08:52AM
Re: create table
2936
Randy Elliott
July 21, 2004 09:02AM
Re: create table
2811
Nick Roper
July 21, 2004 09:11AM
Re: create table
2699
Randy Elliott
July 21, 2004 09:26AM
Re: create table
2750
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.