Out Of Range Value?

[Paula]

Sigh. Just when I solve one set of problems, another one appears. I'm trying to do something seemingly simple in bringing a .txt file into a table. I keep getting this error:

Error Code : 1264

Out of range value adjusted for column 'CSFQTY' at row 1

Here's my script:

CREATE TABLE CRTSTAT

(

CRSIDN int,

primary key (CRSIDN),

TRSIDN int, index(TRSIDN),

AGYTXT varchar(29),

CSCCOD varchar(1),

CAUNBR varchar(20),

FPOCOD varchar(1),

CDDDTE char(10),

GOCCOD varchar(1),

CONCOD varchar(8),

COLTXT varchar(46),

LDCCOD varchar(2),

CDNCOD varchar(3),

DOSDTE char(10),

CSSCOD varchar(12),

CSFQTY int,

CMTCOD varchar(12),

CPRCOD varchar(12),

CFNQTY int,

CSTQTY int,

CPLTXT varchar(50),

CPNNBR varchar(3),

DCADTE char(10),

DDACOD varchar(3),

FCDCOD varchar(3),

ARCTXT varchar(29),

MCCCOD varchar(2),

DMVCOD varchar(1)

)

ENGINE = MYISAM

;

LOAD DATA INFILE 'C:/MYDATA/crt_Stat.txt'

INTO TABLE CRTSTAT

FIELDS TERMINATED BY 't'

Lines terminated by 'rn'

;

I have no idea what to do. My Google research showed that this was some bug, but none of the suggestions seemed to fix it. Thanks for any help…and I'm a newbie so type slow in your response. ( – ;

[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