At 8:34 -0700 5/14/04, David Blomstrom wrote:
>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.
Number syntax is documented in the manual:
http://dev.mysql.com/doc/mysql/en/Number_syntax.html
It doesn't say anything about commas being legal.
>
>I inserted one value - 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 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?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
