其实就是可以对字段使用函数,关键部分已经在上面啦
load data infile ...
truncate into table ...
fields terminated by '|'
trailing nullcols
(name,
sex,
class "substr(:class,1,instr(:class,';')-1)",
score "substr(:class,instr(:class,';'))",
)
load data infile ...
truncate into table ...
fields terminated by '|'
trailing nullcols
(name,
sex,
class "substr(:class,1,instr(:class,';')-1)",
score "substr(:class,instr(:class,';'))",
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货