Re: composite primary keys

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 13 Oct 2007 00:41:04 +0200
Message-ID: <5nabg0Fh9vcvU3@mid.individual.net>

On 10.10.2007 17:34, fitzjarrell_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 Received on Fri Oct 12 2007 - 17:41:04 CDT