bennadel.com bennadel.com

Data Truncation: Truncated Incorrect DOUBLE Value When Updating Timestamp

I just spent the last hour trying to debug the smallest SQL problem! I have a datatable of Contracts and I was building a feature in our client software where we could end all contracts of a certain type (SLA) at the same time (trust me, there is a business reason behind this). To do this, I was executing the following MySQL Cross-Table UPDATE statement:UPDATEcontract cINNER JOINcontract_type tON(t.reference_key =...