Re: composite primary keys

On Mon, 08 Oct 2007 08:44:26 -0700, g.mrunalini 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;

-- 
http://www.mladen-gogala.com