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

" o' k0 J+ \6 M- z) `6 B& z+ B& A
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
/ d( p6 z/ [( C0 Z' P6 s
Records: 0  Duplicates: 0  Warnings: 0

9 n: `/ J8 U% MERROR 1406 (22001): Data too long for column 'shell' at row 2
3 [6 H( ]7 s  _* X报错提示字符太长，导致数据容量过大。
解决办法：
modify 修改字段类型
    modify 字段名 类型（宽度） 约束条件 , modify 修改个多个在后面田间,modify
* g; t$ K5 ~! S3 }, d' J1 Umysql> alter table six modify shell varchar(50);
# l6 v8 K% E, T; _9 @( x0 b
  K- B* v0 R/ V: l2 W1 ^$ bQuery OK, 0 rows affected (1.85 sec)
4 [8 W& B$ p4 S  ^* xRecords: 0  Duplicates: 0  Warnings: 0

mysql> alter table six modify shell varchar(50);
Query OK, 0 rows affected (1.85 sec)

) _* }. t# _- emysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
4 G/ I9 ~3 Y: e* e. i0 Q8 Y* kQuery OK, 24 rows affected (0.29 sec)
Records: 24  Deleted: 0  Skipped: 0  Warnings: 0
9 t* T8 V' p& {) W9 e! M7 F
, X% R, T; K7 L9 y# j5 ?

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
* U  D2 O) a9 p* I7 R& 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
' V) j% x' P* U  Vmysql> 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);
' L! e( c+ ]7 |* k! w& RQuery OK, 0 rows affected (1.85 sec)
Records: 0  Duplicates: 0  Warnings: 0

* {- {. r( Z" B9 \: Imysql> load data infile '/etc/passwd' into table gz.six fields terminated by ':' lines terminated by '\n';
, l+ U7 N% R1 h9 |, ^( z6 t9 dQuery OK, 24 rows affected (0.29 sec)
Records: 24  Deleted: 0  Skipped: 0  Warnings: 0
- B: V8 ?3 I$ H/ u' w- ~0 S

admin

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