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';  
, v1 n) @8 l) TERROR 1406 (22001): Data too long for column 'shell' at row 2


+ c0 R# N% i# k3 ^2 emysql> 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
6 U( e' p. ]" w0 b6 x% @5 m7 ?
Records: 0  Duplicates: 0  Warnings: 0
+ @' O  z4 N6 C1 u9 j2 h. Q
* c7 j/ s' a) Q' lERROR 1406 (22001): Data too long for column 'shell' at row 2
报错提示字符太长，导致数据容量过大。
解决办法：
modify 修改字段类型
    modify 字段名 类型（宽度） 约束条件 , modify 修改个多个在后面田间,modify
mysql> alter table six modify shell varchar(50);
  O- h+ t+ K# y3 x) ?& }0 {$ |4 [
' ]1 H. A3 C3 _) @. V# I- GQuery OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0
5 Z* T: |# V* F4 f6 F
mysql> alter table six modify shell varchar(50);
) h8 Y1 S+ p  w) i3 |5 ^& NQuery OK, 0 rows affected (1.85 sec)

6 Y! R  y- R# `; c! s; r5 V% ^& _mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
2 x" _6 J( |# P+ }$ OQuery OK, 24 rows affected (0.29 sec)
Records: 24  Deleted: 0  Skipped: 0  Warnings: 0
5 B( \! \$ f$ }! w4 s

admin

mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';  
6 n: p& n! X% J# B4 d4 D" u& vERROR 1406 (22001): Data too long for column 'shell' at row 2
  N& ]9 m* y$ w7 N6 Gmysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by'\n';
9 e8 q# e; O5 G* a* @1 H7 MERROR 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';
ERROR 1406 (22001): Data too long for column 'shell' at row 2
& a0 p( h2 k' F4 mmysql> alter table six modify shell varchar(50);
* B( L0 B; v; Z. x! ?Query OK, 0 rows affected (1.85 sec)
( s/ g, t0 \  O4 D1 d! c0 Y  tRecords: 0  Duplicates: 0  Warnings: 0

mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
+ I& V' a0 z2 B6 P$ u7 L  bQuery OK, 24 rows affected (0.29 sec)
Records: 24  Deleted: 0  Skipped: 0  Warnings: 0
9 l* w" r! _- s% L7 E  T. ]

admin

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