title: Finding invalid 0000-00-00 dates on mysql database
body: <p>We are moving our mysql database to strict_all_tables from non-strict mode and would like to find all existing rows with invalid dates (0000-00-00) from all databases and tables on our server. Is there a way to do this by one command or some other simple way?</p>
  
  <p>I would like to know database and table name where the 0000-00-00 value exists, column name would be a plus.</p>
  
  <p>We have quite a large amount of databases with a large set of tables, some containing quite a large amount of data so the more automatic the method, the better.</p>