| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Joshua Beall | Date: | May 14 2004 4:53pm |
| Subject: | Re: Integers - How would you enter 112,249? | ||
| View as plain text | |||
"David Blomstrom" <david_blomstrom@stripped> wrote in message news:20040514153424.64305.qmail@ style="color:#666">stripped... > 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", AFAIK 112,249 is not an integer. It is a string. If you need to have the commas, you need to store it as a string.
| Thread | ||
|---|---|---|
| • Integers - How would you enter 112,249? | David Blomstrom | 14 May |
| • Re: Integers - How would you enter 112,249? | Dan Nelson | 14 May |
| • Re: Integers - How would you enter 112,249? | Paul DuBois | 14 May |
| • Re: Integers - How would you enter 112,249? | Joshua Beall | 14 May |
| • Re: Integers - How would you enter 112,249? | David Blomstrom | 14 May |
| • Re: Integers - How would you enter 112,249? | Paul DuBois | 14 May |
| • Re: Integers - How would you enter 112,249? | SGreen | 14 May |
