title: Error Code: 1265. Data truncated for column at row 1 when I tried to input csv file to MySQL
body: <p>I created a table with a query:</p>
  <pre><code>CREATE TABLE Department (
  EmpID INT NOT NULL,
  Designation VARCHAR(80) NOT NULL,
  Department VARCHAR(80) NOT NULL,
  PRIMARY KEY(EmpID));
  
  SELECT * FROM Department;
  </code></pre>
  <p>I enter data with a query:</p>
  <pre><code>LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Department.csv'
  INTO TABLE Department
  FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\r\n';
  </code></pre>
  <p>But a message appears from the output:</p>
  <pre><code>Error Code: 1265. Data truncated for column 'EmpID' at row 1
  </code></pre>
  <p>Anyway, the EmpID value is no more than 6 digits and the value is positive.</p>
  <p>Is there any solution so I can insert data from csv file?</p>