title: How to import JSON values inside MySQL (10.2.36-MariaDB) table?
body: <p>I have the following JSON file :</p>
  <pre><code>{
    &quot;ID&quot;: 5464015,
    &quot;CUSTOMER_ID&quot;: 1088020,
    &quot;CUSOTMER_NAME&quot;: &quot;My customer 1&quot;
  }
  {
    &quot;ID&quot;: 5220812,
    &quot;CUSTOMER_ID&quot;: 523323,
    &quot;CUSOTMER_NAME&quot;: &quot;My customer 2&quot;
  }
  {
    &quot;ID&quot;: 5205039,
    &quot;CUSTOMER_ID&quot;: 1934806,
    &quot;CUSOTMER_NAME&quot;: &quot;My customer 3&quot;
  }
  </code></pre>
  <p>From a shell script, I would like to import these values into a MariaDB table (MariaDB Server version : 10.2.36-MariaDB) with the related columns already created :</p>
  <ul>
  <li>ID</li>
  <li>CUSTOMER_ID</li>
  <li>CUSTOMER_NAME</li>
  </ul>
  <p>But for CUSTOMER_NAME, I don't want to import double quotes at the beginning and at the end of the value.
  Is there a simple way to do it?</p>
  <p>Or if not possible, If I have a txt or csv file like this :</p>
  <pre><code>5464015,1088020,&quot;My customer 1&quot;
  5220812,523323,&quot;My customer 2&quot;
  5205039,1934806,&quot;My customer 3&quot;
  </code></pre>
  <p>How to import it?</p>
  <p>Many thanks</p>