create table family(
id int auto_increment primary key,
name varchar(10),
sex enum('男','女'),
jiguan varchar(10)
)charset=utf8;
php.txt: 1 赵四 女 山西
mysql> load data infile'C:/Users/Wang Pu/Desktop/php.txt' into table family;
ERROR 1265 (01000): Data truncated for column 'sex' at row 1
为什么会报错