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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]