title: Disabling MySQL Strict Mode
body: <p>I am scanning 5000 csv files into a database. Regrettably the files have '', for 0. Thus when ever I run my script it crashes. I heard that this error is possible to avoid by simply disabling strict mode.  So I attempted to disable strict mode to allow me to read in an empty string as a 0 for my numeric fields. However the error persisted. </p>
  
  <p>So does disabling strict mode allow '' to be read into a int field? (the '' is two qoutes i.e. empty string)</p>
  
  <p>If so why did setting </p>
  
  <p>sql_mode=''</p>
  
  <p>in the my.ini config file not fix the problem.</p>
  
  <p>Thank  you!</p>