It took a long time for me to discover why one particular update/insert in a MySQL database failed while most updates worked OK.  And the failed transactions did not throw an error – they came back via the ‘success’ path. Turns out any single quotes in MySQL string data cause this behavior.  Once I escaped […]