title: Insert blanks as NULL to MySQL
body: <p>I'm building an AWS pipeline to insert CSV files from S3 to an RDS MySQL DB. The problem I'm facing is that when it attempts to load the file, it treats blanks as empty strings instead of NULLs. For example, Line 1 of the CSV is:</p>
  <pre><code>&quot;3&quot;,&quot;John&quot;,&quot;Doe&quot;,&quot;&quot;
  </code></pre>
  <p>Where the value is an integer in the MySQL table, and of course the error in the pipeline is:</p>
  <pre><code>Incorrect integer value: '' for column 'col4' at row 1
  </code></pre>
  <p>I was researching the jdbc MySQL paramaters to modify the connection string:</p>
  <pre><code>jdbc:mysql://my-rds-endpoint:3306/my_db_name?    
  jdbcCompliantTruncation=false
  </code></pre>
  <p><code>jdbcCompliantTruncationis</code> is just an example, is there any of these parameters that can help me insert those blanks as nulls?</p>
  <p>Thanks!</p>
  <p>EDIT:
  A little context, the CSV files are UNLOADS from redshift, so the blanks are originally NULLs when I put them in S3.</p>