load data local infile ‘导入数据地址’
into table 表名
fields terminated by ‘分割条件(""号比较难用于分隔)’;
例子:
load data local infile
‘./root/dataFiles/ODS.dat’
into table org_ln_due fields terminated by ‘,’;
centos6.8 下 MySQL 导入数据
最新推荐文章于 2024-07-16 08:19:13 发布
load data local infile ‘导入数据地址’
into table 表名
fields terminated by ‘分割条件(""号比较难用于分隔)’;
例子:
load data local infile
‘./root/dataFiles/ODS.dat’
into table org_ln_due fields terminated by ‘,’;