Please forgive my ignorance. Going from update to replace and left the 'where' part of the statement. Definitely a "DOH!" moment.
-- John C. Nichel IV System Administrator KegWorks http://www.kegworks.com 716.362.9212 x16 j...@kegworks.com > -----Original Message----- > From: John Nichel [mailto:jnic...@kegworks.com] > Sent: Tuesday, January 26, 2010 12:54 PM > To: mysql@lists.mysql.com > Subject: Need an extra pair of eyes > > I have a query that is giving me fits, but I can't find where there > error is. I know its one of those things that I'll slap myself in the > forehead for not seeing, but after a half an hour, it's all a blur. ;) > If someone can spot it, I'd be most grateful. > > REPLACE INTO product_dimensions SET `productid` = '173846', `variantid` > = '73130', `type` = 's', `height` = '3.7500', `width` = '3.5000', > `depth` = '5.3300' WHERE `productid` = 173846 && `variantid` = 73130 && > `type` = 's' > > I've also tried it this way.... > > REPLACE INTO product_dimensions ( `productid`, `variantid`, `type`, > `height`, `width`, `depth` ) VALUES ( '173846', '73130', 's', '3.7500', > '3.5000', '5.3300' ) WHERE `productid` = 173846 && `variantid` = 73130 > && `type` = 's' > > > And the error for both is the same: > > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 'WHERE > `productid` = 173846 && `variantid` = 73130 && `type` = 's'' at line 1 > > -- > John C. Nichel IV > System Administrator > KegWorks > http://www.kegworks.com > 716.362.9212 x16 > j...@kegworks.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=j...@kegworks.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org