Re: Unexpected Data truncated for Date
A further issue my code works if the server is MariaDB. Issuing the following command manually fails if the server is MySQL but works if it is MariaDB.
UPDATE Deaths SET `d_originalvolume`='', `d_originalpage`='', `d_originalitem`=NULL, `d_calcdate`='1872-07-30',`d_calcbirth`='1871-06-30',D_ChangedBy='jcobban',D_ChangeDate=CURDATE() WHERE D_RegDomain='CAON' AND D_RegYear=1872 AND D_RegNum=25220
Subject
Written By
Posted
Re: Unexpected Data truncated for Date
June 12, 2019 04:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.