title: Error Code: 1366. Incorrect integer value: '#N/A' for column 'Length' at row 21
body: <p>In my dataset, there are many nonsense values of "#N/A". I create a new table and load the local CSV file into my new table. But because of the nonsense value, it shows the error as shown in the headline. How can I load a dataset successfully without the nonsense values?</p>
  
  <p>Here is my code:</p>
  
  <pre><code>CREATE TABLE movies (
      Yearnum INT NOT NULL,
      Length INT,
      Title VARCHAR(255) NOT NULL,
      Subjct VARCHAR(255) NOT NULL,
      Actor VARCHAR(255) NOT NULL,
      Actress VARCHAR(255) ,
      Director VARCHAR(255) ,
      Popularity VARCHAR(255),
      Awards VARCHAR(255) NOT NULL
  );
  LOAD DATA INFILE  'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/movies - movies.csv'
  INTO TABLE movies
  FIELDS TERMINATED BY ',' 
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  IGNORE 1 ROWS;
  </code></pre>
  
  <p>Here is my link url of dataset:<a href="https://docs.google.com/spreadsheets/d/1J17LYPJZaW5QWQuQVJQonpJXGUbPGOJjg5bxj3SMupQ/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1J17LYPJZaW5QWQuQVJQonpJXGUbPGOJjg5bxj3SMupQ/edit?usp=sharing</a></p>