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~' Link to comment https://forums.phpfreaks.com/topic/263417-mysql-error-cant-see-the-problem/ 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 Link to comment https://forums.phpfreaks.com/topic/263417-mysql-error-cant-see-the-problem/#findComment-1350029 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. Link to comment https://forums.phpfreaks.com/topic/263417-mysql-error-cant-see-the-problem/#findComment-1350031 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.