title: MySQL and importing decimals from CSV
body: <p>I'm messing around with MySQL, using the Workbench to import a CSV of building permits in the city.  Two of the columns are latitude and longitude, and because these are relatively precise locations, keeping the decimals is pretty important, there are maximum 6 decimals after many of these entries.  For example, the latitude and longitude columns might say 35.678121, -21.57890</p>
  
  <p>I generated a database using LOAD DATA INFILE, and got all my data in.  I had set the Latitude and Longitude columns as Decimal(6,6), but when all the data was imported in, all of the values in my table say 0.999999 and -0.999999.</p>
  
  <p>What am I doing wrong here?</p>