Try taking out the identifier name for the primary key (pk_foo). The
way I read the documentation, MySQL does not support identifiers or
names for primary keys although it does for other index types.
HTH
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
I did the following (not much different):
CREATE TABLE `foo` (
`pri_1` INT UNSIGNED NOT NULL,
`pri_2` INT UNSIGNED NOT NULL,
`pri_3` INT UNSIGNED NOT NULL,
`test_data` VARCHAR(120) NOT NULL,
PRIMARY KEY (`pri_1`, `pri_2`, `pri_3`)
) TYPE = InnoDB;
Regards,
Ritter
--
Jason k Larson
Fortun
All,
I've got an InnoDb table that requires a composit key constraint. However,
I'm not certain how to word the DDL syntax.
Pretending for a sec this was SQL Server 2000 or Sybase ASE 12.5 I'd use the
following.
CREATE TABLE foo(
pri_1 INTEGER NOT NULL,
pri_2 INTEGER NOT NULL,
pri_3 INTEGER
