mysqllines
文本内容
1,"zhangsan","f"
2,"lisi","m"
3,"zhaoliu","f"
建表
create table mytable(
id int(20),
name varchar(20),
gender char(1)
);
把文本内容写到表中
load data infile 'f:b.txt' replace into table mytable
fields terminated by ',' enclosed by '"'
lines terminated by '\n'(id,name,gender);
mysql> load data infile 'f:b.txt' replace into table mytable
-> fields terminated by ',' enclosed by '"'
-> lines terminated by '\n'(id,name,gender);
ERROR 1406 (22001): Data too long for column 'gender' at row 1
怎么把文件里的内容写到表中啊！！！！！
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
191
收藏
