MySQL Forums
Forum List  »  PHP

Re: Unexpected Data truncated for Date
Posted by: James Cobban
Date: June 12, 2019 04:24PM

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

Options: ReplyQuote

Written By
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.