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

5 D6 C9 ?' Q% T0 u; y* r6 @, J" C
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
; i8 X- h4 X- [2 [7 m- D5 W2 i/ ^ERROR 1406 (22001): Data too long for column 'shell' at row 2

; N+ \! ~/ `2 T9 \- nRecords: 0  Duplicates: 0  Warnings: 0

  E& q4 o$ x" xERROR 1406 (22001): Data too long for column 'shell' at row 2
$ Z: e: u( n0 J& Z2 D4 t( L报错提示字符太长，导致数据容量过大。
解决办法：
2 P$ Q2 z: t+ `7 D# vmodify 修改字段类型
$ E! i. v6 `- n7 A4 ^( |5 ?+ t( w    modify 字段名 类型（宽度） 约束条件 , modify 修改个多个在后面田间,modify
1 F2 @2 ]! w4 a3 c1 ~mysql> alter table six modify shell varchar(50);
5 U/ G( ~; C- M( L9 b4 ~5 R
2 _# w4 c- q0 C6 u* z7 H$ Z4 ?Query OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0

" W6 J" Z, J- S! ~5 T' d' B; Xmysql> alter table six modify shell varchar(50);
Query OK, 0 rows affected (1.85 sec)
/ U  v0 V: ?4 Y8 L& o# q1 o
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
/ p6 ?2 B4 @; M! i$ gQuery OK, 24 rows affected (0.29 sec)
Records: 24  Deleted: 0  Skipped: 0  Warnings: 0
  `( i, x1 z" Q

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
$ P8 |- p; v' |5 Zmysql> 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 b6 y4 k/ x4 rmysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
$ r% I2 X. S, ~" a% I; sERROR 1406 (22001): Data too long for column 'shell' at row 2
mysql> alter table six modify shell varchar(50);
2 x; c+ k' ?! ^" iQuery OK, 0 rows affected (1.85 sec)
4 [1 u; ?# \0 N) y3 v2 H& @% ?3 aRecords: 0  Duplicates: 0  Warnings: 0

mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
, k( m( {6 f: e4 z: L1 FQuery OK, 24 rows affected (0.29 sec)
- ]5 ^! m: G1 A4 u9 Y( q1 y) [; @Records: 24  Deleted: 0  Skipped: 0  Warnings: 0
( E2 h- Q  F! O# u8 N* }6 R# `

admin

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