title: mysql table formatting and infile issue
body: <p>Each time I go and create my table and then add the .csv file, it keeps not fully loading in all of the data. Below is my code:</p>
  <pre><code>CREATE TABLE Parts_Maintenance (
  Vehicle_ID BIGINT(20),
  State VARCHAR(255),
  Repair VARCHAR(255),
  Reason VARCHAR(255),
  Year YEAR,
  Make VARCHAR(255),
  Body_Type VARCHAR(255),
  PRIMARY KEY (Vehicle_ID)
  );
  </code></pre>
  <pre><code>LOAD DATA INFILE '/home/codio/workspace/FleetMaintenanceRecords.csv'
  INTO TABLE Parts_Maintenance
  FIELDS TERMINATED BY ','
  ENCLOSED BY '&quot;'
  LINES TERMINATED BY '\\n'
  IGNORE 1 ROWS;
  </code></pre>
  <pre><code>SELECT * FROM Parts_Maintenance;
  </code></pre>
  <p>Here is a photo of what it looks like in Codio:</p>
  <p><a href="https://i.stack.imgur.com/KG5IW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KG5IW.png" alt="enter image description here" /></a></p>
  <p>And here is a photo of some of the data being brought in:</p>
  <p><a href="https://i.stack.imgur.com/78Kmi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/78Kmi.png" alt="enter image description here" /></a></p>
  <p>Could someone please help me pinpoint what I am doing wrong?</p>
  <p>Tried to create table and bring in a .csv file. Table was created but the data is not all there and the table looks messed up</p>