Out Of Range Value?

[peterlaursen]

This column is an integer.

Do you have date exceeding the range as described here:

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

“All integer types can have an optional (non-standard) attribute UNSIGNED. Unsigned values can be used when you want to allow only non-negative numbers in a column and you need a larger upper numeric range for the column. For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift from -2147483648 and 2147483647 up to 0 and 4294967295.”

You could then make it a BIGINT …

[Paula]

peterlaursen wrote on Nov 7 2006, 10:42 PM:

This column is an integer.

Do you have date exceeding the range as described here:

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

“All integer types can have an optional (non-standard) attribute UNSIGNED. Unsigned values can be used when you want to allow only non-negative numbers in a column and you need a larger upper numeric range for the column. For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift from -2147483648 and 2147483647 up to 0 and 4294967295.”

You could then make it a BIGINT …

No, none of those figures would be larger than 8 characters. Changing it to BIGINT didn't work anyhow.

[peterlaursen]

“I'm trying to do something seemingly simple in bringing a .txt file into a table.”

Are you using CSV-import with SQLyog?

Could you provide a small test case?

What are exact program versions?

There are no decimal numbers in your data?

[Author]

Posts