RE: Changed Number
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 PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 April 2005 02:31 To: mysql@lists.mysql.com Subject: Changed Number 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 have reloaded, checked formatting and done various other things without success. Then I went to the text (*.sql) file in which I had dumped the mysql table, manually changed the number to 16996941 and put the text file on the server. However, the number that showed up on the web page table and the number in the database on the server is 8388607. Note that the smaller number is just under half of the larger number. This makes no sense. Any solutions? Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Changed Number
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 have reloaded, checked formatting and done > various other things without success. Then I went to the text (*.sql) > file in which I had dumped the mysql table, manually changed the > number to 16996941 and put the text file on the server. However, the > number that showed up on the web page table and the number in the > database on the server is 8388607. Note that the smaller number is > just under half of the larger number. > This makes no sense. Any solutions? My crystal ball says that the column type in question is a signed MEDIUMINT. Use a longer INT type. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Changed Number
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. I have reloaded, checked formatting and > done various other things without success. Then I went to the text > (*.sql) file in which I had dumped the mysql table, manually changed > the number to 16996941 and put the text file on the server. However, > the number that showed up on the web page table and the number in the > database on the server is 8388607. Note that the smaller number is > just under half of the larger number. This is exactly the maximum value of a signed mediumint. Might I suggest a column type of int or bigint. In a numeric field, anything over the maximum will be converted to the maximum, and anything under the minimun will be converted to the minimun. > This makes no sense. Any solutions? > > Ken -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Changed Number
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 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 have reloaded, checked formatting and done various other things without success. Then I went to the text (*.sql) file in which I had dumped the mysql table, manually changed the number to 16996941 and put the text file on the server. However, the number that showed up on the web page table and the number in the database on the server is 8388607. Note that the smaller number is just under half of the larger number. This makes no sense. Any solutions? Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Changed Number
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@lists.mysql.com Subject: Changed Number 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 have reloaded, checked formatting and done various other things without success. Then I went to the text (*.sql) file in which I had dumped the mysql table, manually changed the number to 16996941 and put the text file on the server. However, the number that showed up on the web page table and the number in the database on the server is 8388607. Note that the smaller number is just under half of the larger number. This makes no sense. Any solutions? Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]