title: mysql [Row 1 was truncated; it contained more data than there were input columns] ERROR
body: <p>my text file is like this.
  <a href="https://drive.google.com/open?id=1faW_OkO7_VoEQL_gndFIOrJv2e4Ycuzo" rel="nofollow noreferrer">https://drive.google.com/open?id=1faW_OkO7_VoEQL_gndFIOrJv2e4Ycuzo</a></p>
  
  <p>and my table is here.</p>
  
  <pre><code>CREATE TABLE news(
      num INT auto_increment primary key,
      link VARCHAR(150),
      date INT,
      title VARCHAR(150) unique,
      description TEXT 
  );
  </code></pre>
  
  <p>i try </p>
  
  <pre><code>LOAD DATA INFILE 'test.txt'
      INTO TABLE news
      CHARACTER SET utf8mb4
      FIELDS
      TERMINATED BY ', ' OPTIONALLY ENCLOSED BY '"' 
      LINES
      TERMINATED BY '\n' (link, date, title, description);
  </code></pre>
  
  <p>but it not working what is my mistake?</p>