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';  
8 w9 M/ B% q) C1 @ERROR 1406 (22001): Data too long for column 'shell' at row 2

% j, P5 D5 A) A- k' w5 V2 F
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
* ?/ n/ O0 f0 `" W" Z* PERROR 1406 (22001): Data too long for column 'shell' at row 2
: s" o* o% K1 W0 S
9 n5 @! L2 k' L% jRecords: 0  Duplicates: 0  Warnings: 0

" l+ I& E8 t9 fERROR 1406 (22001): Data too long for column 'shell' at row 2
报错提示字符太长，导致数据容量过大。
2 {0 T. R6 B8 q) _% d* M9 V- q解决办法：
" |! m  U' b/ l3 E& C; v4 zmodify 修改字段类型
6 u. H0 }9 z5 r1 O& Y    modify 字段名 类型（宽度） 约束条件 , modify 修改个多个在后面田间,modify
& |, M6 ]0 E9 g( amysql> alter table six modify shell varchar(50);
# D5 |/ F9 V  r* z
1 c* z2 n( D) V( vQuery OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0
9 f4 c' f+ m$ E6 \! u( K
mysql> alter table six modify shell varchar(50);
Query OK, 0 rows affected (1.85 sec)
4 \7 v% ^/ q3 i) q. d
( B9 D% ]0 b. [mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
/ d6 }6 Z* R. B" J! I! tQuery OK, 24 rows affected (0.29 sec)
Records: 24  Deleted: 0  Skipped: 0  Warnings: 0

' \8 r7 f3 ?" S* J' K4 h5 c

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 n% J% |, P) R7 u4 ?mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by'\n';
* ]3 G9 i3 l0 f2 xERROR 1406 (22001): Data too long for column 'shell' at row 2
! L, _% ]& Z% z# U, F. N# y' vmysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
# Q$ ]- u) h( a  ^( L! ?ERROR 1406 (22001): Data too long for column 'shell' at row 2
7 C5 e$ z7 D9 z: G! M$ e, V/ c& Fmysql> alter table six modify shell varchar(50);
Query OK, 0 rows affected (1.85 sec)
( G) R) h. n* ?Records: 0  Duplicates: 0  Warnings: 0
6 ]4 p8 [: M7 h; D" ~: ?
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
1 i2 f' |& A  N2 K" F: WQuery OK, 24 rows affected (0.29 sec)
* v, d! @* J) q* f& z/ RRecords: 24  Deleted: 0  Skipped: 0  Warnings: 0
# t- `; I: W$ O3 ?! Z$ C

admin

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