On 15.10.2007 16:08, fitzjarrell_at_cox.net wrote:
> 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.
Too bad I did not hear it. :-)
robert
Received on Tue Oct 16 2007 - 11:37:46 CDT