Hello All:
using MYSQL Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) (RH 7.2)
I have data exported from an excel spreadsheet as tab delimited text.
Certain columns need to go to mysql table columns with a type of int(11).
(alternative datatypes will be considered)
The data from the spreadsheet have formats that include
enclosed quotes, dollar signs commas and are of a decimal
format. Using vim, I can safely remove the quotes and the
dollar signs:
as in "$2,456.12345" -> 2,456.12345
I am afraid that attempting to use vim to remove the
commas will have unpredictable side effects in other
columns.
1)Will 2,456.12345 import safely into an int(11) column?
If not, may an alternative datatype be recomended?
NOTE: the number that I want to have (using the example above)
would be 2456 rounded to the nearest 'whole number'.
Any help is appreciated. Pointers to documentation is welcome
as well. I hope I've provided enough info here.
regards
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
