Re: two-field primary key update issue

# [EMAIL PROTECTED] / 2003-06-29 23:24:58 -0500: > > > # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500: > > > CREATE TABLE extraFieldOptions ( > > > fieldID tinyint(3) unsigned NOT NULL default '0', > > > fieldOption varchar(16) NOT NULL default '', > > > fieldValue varchar(16) NOT NULL defa

Re: two-field primary key update issue

> # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500: > > CREATE TABLE extraFieldOptions ( > > fieldID tinyint(3) unsigned NOT NULL default '0', > > fieldOption varchar(16) NOT NULL default '', > > fieldValue varchar(16) NOT NULL default '', > > PRIMARY KEY (fieldID,fieldOption) > > ) TYPE=M

Re: two-field primary key update issue

# [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500: > CREATE TABLE extraFieldOptions ( > fieldID tinyint(3) unsigned NOT NULL default '0', > fieldOption varchar(16) NOT NULL default '', > fieldValue varchar(16) NOT NULL default '', > PRIMARY KEY (fieldID,fieldOption) > ) TYPE=MyISAM; > mysq

two-field primary key update issue

I have a table with a two-field primary key, it's structure is like this: CREATE TABLE extraFieldOptions ( fieldID tinyint(3) unsigned NOT NULL default '0', fieldOption varchar(16) NOT NULL default '', fieldValue varchar(16) NOT NULL default '', PRIMARY KEY (fieldID,fieldOption) ) TYPE=M