INSERT INTO part_numbers_master ('pn_full' ,'factory_code', 'rohs_compliancy_flag', 'discontinued_flag') VALUES ('1062-002', '683261-210', 'unknown', 'n') ON DUPLICATE KEY UPDATE factory_code='683261-210', rohs_compliancy_flag='unknown', discontinued_flag='n';
Pretty straight forward - I've checked and re-checked the syntax and I can't find anything wrong with it.
I'm getting this error:
ERROR 1064 (42000): 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 ''pn_full' ,'factory_code', 'rohs_compliancy_flag', 'discontinued_flag') VALUES (' at line 1
Any ideas on what flavor of crack my db is smoking?
Am I so blind to be missing something blatently obvious?