title: Mariadb alter table column data type error, wrong column
body: <p>I am having a bit of a problem with mariadb with the following query  </p>
  
  <p><code>ALTER TABLE archive_maindata CHANGE monthly_income monthly_income decimal(25,4) DEFAULT '0.0000';</code></p>
  
  <p>but I got this error,</p>
  
  <p><code>Additional information: Incorrect date value: '0000-00-00' for column 'expiry_date' at row 3</code>'</p>
  
  <p>I can't figure out what it is that I am doing wrong, I am not trying to change the expire_date column as you can see in the query. Any help would be appreciated
  Thanks in advance</p>