Re: composite primary keys

On Oct 12, 5:41 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On 10.10.2007 17:34, fitzjarr..._at_cox.net wrote:
>
>
>
>
>
> > 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.
>
> ROTFL
>
> Did you mean "WE know it won't work with Oracle"? ;-)
>
> robert- Hide quoted text -
>
> - Show quoted text -

I said what I meant, and I meant what I said.

David Fitzjarrell Received on Mon Oct 15 2007 - 09:08:15 CDT