Hi,
I am using Spreadsheet::ParseExcel, DBI DBD::mysql to capture and
insert data into mysql tables. That's working out very well but I am
having issues with one datatype. When I capture percentages out of excel
97 the captured value might be 0.76324095 but when I attempt to select
that same
Hello Hagen,
Hagen Finley wrote:
Should I be using a different datatype for these kind of numerical
values?
Yes. INT is by definition a whole number (0, 1, 2 etc.)
You will want to change the fmarg column to DOUBLE or DECIMAL.
Regards,
Andy
--
MySQL General Mailing List
For list