List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 14 2004 3:57pm
Subject:Re: Integers - How would you enter 112,249?
View as plain text  
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
Thread
Integers - How would you enter 112,249?David Blomstrom14 May
  • Re: Integers - How would you enter 112,249?Dan Nelson14 May
  • Re: Integers - How would you enter 112,249?Paul DuBois14 May
Re: Integers - How would you enter 112,249?Joshua Beall14 May
  • Re: Integers - How would you enter 112,249?David Blomstrom14 May
    • Re: Integers - How would you enter 112,249?Paul DuBois14 May
Re: Integers - How would you enter 112,249?SGreen14 May