Ken
Looks like you used a medium int field on the mysql table - if you import a
figure that is too big for the medium int to handle - on overflow it places
a value of 8388607 into the colum. You need to change to an integer column.
Regards
Tim hayes
-Original Message-
From: [EMAIL PROTEC
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> I have loaded a large *.csv spreadsheet into mysql and one number, the
> grand total, changes from 16996941 on the Excel spreadsheet to 8388607
> in the mysql database. The numbers surrounding this number are
> correct at all stages. I
On Tuesday, April 05, 2005 20:31, [EMAIL PROTECTED] wrote:
> I have loaded a large *.csv spreadsheet into mysql and one number, the
> grand total, changes from 16996941 on the Excel spreadsheet to
> 8388607 in the mysql database. The numbers surrounding this number
> are correct at all stages.
Maybe a review of http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
will help?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:31 PM
To: mysql@lists.mysql.com
Subject: Changed Number
I have loaded a large *.csv spreadsheet
Sounds like the type for the field you're storing the number is not capable of
holding a number sized as 16996941. What's the field type you're storing the
number in?
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:31 PM
To: mysql