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';  
' \: ]9 H3 `3 qERROR 1406 (22001): Data too long for column 'shell' at row 2


( F( ?/ Q; @% }" F$ Y" m. umysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
4 B. _) o. t$ Q2 O; Y' C6 L' eERROR 1406 (22001): Data too long for column 'shell' at row 2

Records: 0  Duplicates: 0  Warnings: 0
9 ]. z! O( d- Z) }. {0 U" H
ERROR 1406 (22001): Data too long for column 'shell' at row 2
; h6 N4 b; z0 G$ b+ j2 q6 ~报错提示字符太长，导致数据容量过大。
  f3 p  g7 [( r* R+ e, d解决办法：
modify 修改字段类型
    modify 字段名 类型（宽度） 约束条件 , modify 修改个多个在后面田间,modify
# f# _! W8 d6 _: K. Fmysql> alter table six modify shell varchar(50);
1 Y* ]0 c3 N# W) K, P6 U% ]# ~( U
Query OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0
4 w/ b4 a8 d/ f; ~% g
mysql> alter table six modify shell varchar(50);
7 Z" n% u8 C* h0 }7 FQuery OK, 0 rows affected (1.85 sec)
! T- W) \4 u6 W3 D$ ]  Y
/ T+ g; a* L8 P+ q# `% ~/ K' fmysql> 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
5 G3 C( @& J# F% j3 y0 L$ x& ~- g. O

admin

mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';  
/ l6 [3 a3 ]" Q2 i" QERROR 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';
- r% W! e- ]; ?! w0 v3 HERROR 1406 (22001): Data too long for column 'shell' at row 2
, I( x3 n8 E. r; d0 m: }mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
6 \( W+ X: ?2 ~7 |ERROR 1406 (22001): Data too long for column 'shell' at row 2
# M. ?3 k% d# kmysql> alter table six modify shell varchar(50);
2 M4 L  ?" s& [Query OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0

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)
0 v* L% R/ y7 W- \/ x, {Records: 24  Deleted: 0  Skipped: 0  Warnings: 0

admin

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