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.
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?
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
