Migrating mysql

update tran set timemodify = ‘2010-01-01 00:00:00’ WHERE CAST(timemodify AS CHAR) = ‘0000-00-00 00:00:00’ ;


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *