silkfire Posted May 31, 2012 Share Posted May 31, 2012 I made this query and looked through the manual and as far as I'm concerned can't see what's wrong with my query. Why are MySQL errors so extremely unhelpful? Surely they could've improved the parsing engine by now? INSERT INTO `$batch_comments` (`plant`, `sap_code`, `batch`, `reason`, `comments_sm`, comments_sc) VALUES('SE23', 'PAN-6587', '165701C~', 'wohooo', '', '') ON DUPLICATE KEY UPDATE `reason` = 'wohooo', `comments_sm` = '', `comments_sc` = '' WHERE `plant` = 'SE23' AND `sap_code` = 'PAN-6587' AND `batch` = '165701C~' Quote Link to comment Share on other sites More sharing options...
Barand Posted May 31, 2012 Share Posted May 31, 2012 At least you have the advantage of knowing what was in the error message Quote Link to comment Share on other sites More sharing options...
silkfire Posted May 31, 2012 Author Share Posted May 31, 2012 I figured it out. ON DUPLICATE KEY UPDATE does not allow a WHERE clause. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.