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
( M9 @2 A; H7 K' r8 x/ Z/ w

: j# n  q) P0 g% p0 p; d4 S- Imysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
( f0 T* Y; j8 G5 R' FERROR 1406 (22001): Data too long for column 'shell' at row 2
- v- d; w8 p. @9 M
Records: 0  Duplicates: 0  Warnings: 0

+ ^6 [! D- {2 Q% s. z3 q) X3 UERROR 1406 (22001): Data too long for column 'shell' at row 2
# Z: t) J  \' o. g  s( H5 B报错提示字符太长，导致数据容量过大。
/ U! ?8 a1 F$ V+ r: B5 v- V解决办法：
+ y  O6 |3 U3 Y1 t0 t7 a5 Wmodify 修改字段类型
    modify 字段名 类型（宽度） 约束条件 , modify 修改个多个在后面田间,modify
" U0 m+ H0 @$ Y) H0 [, ~6 E6 g: s/ ^+ smysql> alter table six modify shell varchar(50);

% J) e1 H1 c, W8 d6 e6 k8 C% CQuery OK, 0 rows affected (1.85 sec)
% d8 Q! t/ a$ J- O$ b; J# `Records: 0  Duplicates: 0  Warnings: 0
, _% l+ {$ S* e8 v7 M
mysql> alter table six modify shell varchar(50);
8 @+ u+ t* _. T) ]+ N( bQuery OK, 0 rows affected (1.85 sec)
5 h2 H) P& P- F8 u3 V9 F( C- F
mysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
) j0 O! P+ I2 |4 {; LQuery 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';  
ERROR 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
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
mysql> alter table six modify shell varchar(50);
Query OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0

6 j9 d3 C/ Q1 B/ M5 C7 I. P7 U& Emysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
Query OK, 24 rows affected (0.29 sec)
7 @+ b9 V* ~( L( S; e- q$ iRecords: 24  Deleted: 0  Skipped: 0  Warnings: 0
3 V- b" U) }" [' q2 i# G

admin

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