From: Dan Nelson
Date: May 14 2004 3:57pm
Subject: Re: Integers - How would you enter 112,249?
List-Archive: http://lists.mysql.com/mysql/165440
Message-Id: <20040514155757.GT81440@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 14), David Blomstrom said:
> 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:
> 
> "112,249","al","Calhoun","county",
> 
> I don't see anything wrong with that, so I assume the problem lies
> with my table set up. I've tried various combinations without
> success.

Commas are not part of the number.  Just insert "112249".

-- 
	Dan Nelson
	dnelson@stripped