When I try to import my csv file in MySQL-Front, it appears to get hung up on every integer - or perhaps it's just every integer in the first integer field.

When it cites an error, it only lists the numerals after the comma. For example, it says 249 for this sample from my csv file:


I inserted 112,249 direcly with phpMyAdmin, and it did just the opposite - it only displays 112. I though perhaps it would automatically insert the comma if I just inserted the six numerals, but it doesn't.

Could someone tell me all the table structure values you would use, assuming this field is not an index or key?

I prsently have...

int(10) | | Yes | NULL

I deleted the length, but it inserted 11 by default.

Any tips?