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
> -----Original Message-----
> From: John Nichel [mailto:jnichel@stripped]
> Sent: Tuesday, January 26, 2010 12:54 PM
> To: mysql@stripped
> 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',
> = '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.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
> to your MySQL server version for the right syntax to use near 'WHERE
> `productid` = 173846 && `variantid` = 73130 && `type` = 's'' at line
> John C. Nichel IV
> System Administrator
> 716.362.9212 x16
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: