将exec中的数据转换为sql语句,
函数:
=CONCATENATE("INSERT INTO team(code,en_name,zh_name,zht_name,en_shortname,zh_shortname,zht_shortname,city_id,found,stadium_id,logo,nickname,fifaname) VALUES('",E2,"', '",C2,"', '",D2,"', '",D2,"','",G2,"', '",F2,"','",F2,"','",A2,"','",A2,"','",A2,"','",A2,"','",A2,"','",B2,"');")
遇到的错误:
执行sql语句:
INSERT INTO `ole`.`team` (`id`, `code`, `en_name`, `zh_name`, `zht_name`, `en_shortname`, `zh_shortname`, `zht_shortname`, `city_id`, `found`, `stadium_id`, `logo`, `nickname`, `fifaname`) VALUES ('691','691',
'Cote d`Ivoire','象牙海岸','象牙海岸','Cote d`Ivoire','科特迪瓦','科特迪瓦','691',null,'691','691','691','CIV');
注意:数值中包含有单引号的数据,把“ ‘ ”改为 “ · ”,否则插入语句报错。