|
|
 leo - 2005-07-12 16:52:49
In case you have a simple table with multiple Primary Keys eg:
CREATE TABLE `item_subitem` (
`itemid` int(5) unsigned NOT NULL default '0',
`subitemid` int(5) unsigned NOT NULL default '0',
PRIMARY KEY (`itemid`,`subitemid`)
) TYPE=MyISAM
The script will generate the following:
create table item_subitem
(
itemid int unsigned primary key,
subitemid int unsigned primary key
);
And this will throw an error while trying to execute:
ERROR 1068 (42000) at line 256: Multiple primary key defined
Is there any maintenance of this script?
 Can Ince - 2005-07-12 19:39:28 - In reply to message 1 from leo
Only one primary key may be defined for the same table.
So, it's not a bug.
 leo - 2005-07-12 20:19:42 - In reply to message 2 from Can Ince
Im afraid not. You may have a goup of fields, assigned as a primary key, in the same table.
They would be foreign keys, also
 leo - 2005-07-12 20:22:11 - In reply to message 2 from Can Ince
By the way.. if you run this:
CREATE TABLE `item_subitem` (
`itemid` int(5) unsigned NOT NULL default '0',
`subitemid` int(5) unsigned NOT NULL default '0',
PRIMARY KEY (`itemid`,`subitemid`)
) TYPE=MyISAM
you will fin that it's a perfectly valid statement.
Actually, the example above, is a table definition in an existing database. And the code below, was generated by this script.
 Can Ince - 2005-07-12 21:27:09 - In reply to message 4 from leo
Well, it's still only one primary key.. However, I apologize as I misunderstood the question. Probably, a case where multiple coloumns will be added to the primary key, is forgotten.
Let me -and the author of course!- check the code against it.
|