Re: composite primary keys

From: <fitzjarrell_at_cox.net>
Date: Wed, 10 Oct 2007 08:34:14 -0700
Message-ID: <1192030454.402007.320130@g4g2000hsf.googlegroups.com>

On Oct 10, 9:59 am, "Martijn Tonies" <m.ton..._at_upscene.removethis.com> wrote:
> > > What is the syntax for composite primary key to a table. The table
> > > already contains primary key as one column and I need to create
> > > composite primary key for three other columns in the same table.
>
> > CREATE TABLE 'mytable' (
> > COL1 SMALLINT AUTOINCREMENT,
> > COL2 CHAR(32),
> > COL3 FLOAT,
> > PRIMARY KEY (COL1,COL2))
> > ENGINE=MyISAM;
>
> This won't work on Oracle.
>
> --
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> MS SQL Server
> Upscene Productionshttp://www.upscene.com
> My thoughts:http://blog.upscene.com/martijn/
> Database development questions? Check the forum!http://www.databasedevelopmentforum.com

You miss the joke, obviously. We KNOW it won't work with Oracle.

David Fitzjarrell Received on Wed Oct 10 2007 - 10:34:14 CDT