
mysql --local-infile -u root -p
set global local_infile = 1;
load data local infile '目录' into able '表名' fields terminated by ',' lines terminated by '\n';







本文演示了如何通过MySQL的`LOADDATALOCALINFILE`命令,以root用户身份,启用`local_infile`选项,从指定目录导入数据到特定表中。数据文件的字段由逗号分隔,行由换行符终止。

mysql --local-infile -u root -p
set global local_infile = 1;
load data local infile '目录' into able '表名' fields terminated by ',' lines terminated by '\n';








被折叠的 条评论
为什么被折叠?