这是我要导入的表:
create table if not exists Medici(
m_id int unsigned AUTO_INCREMENT PRIMARY KEY,
m_nume VARCHAR(50),
m_prenume VARCHAR(50),
Statut ENUM('primar', 'specialist'),
Specialitate VARCHAR(50)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
CSV的开头是:
Nume,Prenume,Tip,Specialitate
Bunica,Mihai-Daniel,primar,reumatologie
Donca,Cornelia-Ana,primar,chirurgie
Achiriloaie,Lorand-Levente,specialist,neurologie
我写的代码是:
load data infile 'D:/xxxxxxxxxxxxx/xxxxxxx/xxxxxxxxxx/xxxxxx/xxxxxxxxxx/medici.txt'
into table Medici
character set utf8
fields terminated by ','
lines starting by 'Nume,Prenume,Tip,Specialitate\n'
terminated by '\n'
(m_nume,m_prenume,Statut,Specialitate);
注意:我用\n
,\r
,\r\n
终止,我仍然得到1行。即使删除了以和结尾的行,它也不起作用。
注意:我贴得很快,有点乱,有4行。我假设CSV格式正确
更多的代码在这里:
Nume,Prenume,Tip,Specialitate
Bunica,Mihai-Daniel,primar,reumatologie
Donca,Cornelia-Ana,primar,chirurgie
Achiriloaie,Lorand-Levente,specialist,neurologie
Papuc,Raducu-Liviu,primar,homeopatie
Cucuiu,Nutu,primar,ortopedie
Buia,Tache,specialist,ginecologie
Dragomanu,Mitrut,specialist,ecografie
Ticu,Simona,specialist,psihiatrie
Ene,Adrian-Stefan,specialist,pediatrie
Copae,Toma,primar,neurologie
Hotoi,Dragos Alin,specialist,pediatrie
Ceafalau,Vincenţiu Mihail,primar,pediatrie
Briceag,Anca Stefana,primar,imagistica
Condrea,Nutu,primar,fizioterapie
Cruceru,Ioana-Loredana,primar,dermatologie
Soarece,Dan-Cristian,primar,o.r.l.
Tatasel,Alexandru-Ovidiu,specialist,psihologie
Sterian,Gologaneanu,primar,chirurgie
Postelnicu,Habib,primar,chirurgie
Silviu ,Adrian Ionut,primar,dermatologie
Paius,Ioana,specialist,ortopedie
Borza,Marius Florian,specialist,fizioterapie
Tamas,Ciprian Costel,primar,chirurgie
Ograzeanu,Cristina Alexandra,primar,endocrinologie
Rildo,Alex,specialist,ecografie
在CSV中,这些行被合并(一行到另一行),例如:在reumatologie
之后,它以名称开始,但当我粘贴代码时,您可以看到它实际上是\n Bunica,Mihai-Daniel,primar,reumatologieDonca,
(....这里是第二排,依此类推)
1条答案
按热度按时间7gs2gvoe1#
试试这个命令:
加载数据本地infile
'D:/xxxxxxxxxxx/xxxxxxx/xxxxxxxx/xxxxxx/xxxxxxxx/medici.txt'
进入表Medici字符集utf8字段以','结尾
行以'\n'忽略1行(m_nume,m_prenume,Statut,Specialitate)终止;