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=MyISAM;
I can't figure out how to update the 'fieldValue' for a given row, here is my
query:
update
extraFieldOptions
set
fieldValue = 'horizontal'
where
fieldID = '2'
and
fieldOption = 'alignment'
mysql> update extraFieldOptions set fieldValue = 'horizontal' where fieldID
= '2' and fieldOption = 'alignment';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
MySQL doesn't produce an error.. but I think maybe it's the 'and' in my where
clause that isn't working. I have looked high and low for an example of such a
query but cannot find anything. Any help would be greatly appreciated. Thanks.
--
Greg Donald
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
