ERROR 1406 (22001): Data too long for column 'shell' at row 2 解决办法

admin

mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';  
ERROR 1406 (22001): Data too long for column 'shell' at row 2

( T2 o6 @- u% e1 T( ]) f1 F
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
ERROR 1406 (22001): Data too long for column 'shell' at row 2

Records: 0  Duplicates: 0  Warnings: 0

8 m, G4 d* m7 @- m2 y" X5 cERROR 1406 (22001): Data too long for column 'shell' at row 2
报错提示字符太长，导致数据容量过大。
解决办法：
modify 修改字段类型
4 }7 u7 l2 F) W9 ^( a  V    modify 字段名 类型（宽度） 约束条件 , modify 修改个多个在后面田间,modify
' {* l! Y4 ]' L+ n" y$ a! }& {" \mysql> alter table six modify shell varchar(50);

" I. x' @; U) O1 s" R8 HQuery OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table six modify shell varchar(50);
, g( H# W; c7 `- e$ aQuery OK, 0 rows affected (1.85 sec)

mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
Query OK, 24 rows affected (0.29 sec)
Records: 24  Deleted: 0  Skipped: 0  Warnings: 0

admin

mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';  
" h- V! H( O' S8 }) ~$ BERROR 1406 (22001): Data too long for column 'shell' at row 2
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by'\n';
$ o9 {7 D" h# o$ R, Y9 S, A- S5 k4 rERROR 1406 (22001): Data too long for column 'shell' at row 2
0 @: E2 {! R( Y1 `7 r9 }- ~7 o9 ~mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
, E( S- k2 n+ S# JERROR 1406 (22001): Data too long for column 'shell' at row 2
1 s0 v) s* S; o* Umysql> alter table six modify shell varchar(50);
Query OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0
8 l6 a+ h( J0 ?9 S# c1 {
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
3 L; g- q7 K4 q3 w7 D- \$ U' bQuery OK, 24 rows affected (0.29 sec)
, z. [' N$ E. I0 y' X, zRecords: 24  Deleted: 0  Skipped: 0  Warnings: 0
  c$ x+ g' I6 E2 O

admin

为了避免类似问题再次发生，可以使用定义参数限制条件大一点。