Uyingenisa njani i-txt kwitafile yedatha yeMySQL?Ngenisa ifayile ye-sql kwi-tutorial yedatha

MySQLUyingenisa njani idatha yetafile kwi-txt?ngenisa ifayile ye-sqlMySQL databaseIzifundo

Idatha yokungenisa i-MySQL

Kukho iindlela ezimbini ezilula zokungenisa idatha ethunyelwa ngaphandle yi-MySQL kwi-MySQL.

Thatha ngaphandle idatha usebenzisa LOAD DATA

Ingxelo ye-LOAD DATA INFILE inikwe kwi-MySQL ukufaka idatha.Lo mzekelo ulandelayo uyakufunda ifayile yokulahla.txt kulawulo lwangoku kwaye ufake idatha kwifayile kwitafile yemytbl yesiseko sedatha yangoku.

mysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl;

　Ukuba igama elingundoqo LOCAL lixeliwe, libonisa ukuba ifayile ifundwa ngendlela kumxhasi womxhasi.Ukuba ayichazwanga, ifayile ifundwa ngendlela kumncedisi.

Ungakhankanya ixabiso lekholamu izahlukanisi kunye neziphawuli zokuphela komgca ngokucacileyo kwingxelo ye LOAD DATA, kodwa abamakishi abangagqibekanga ngabo.Ukubekwa endaweniabalinganiswa kunye nemigca yekhefu.

Isivakalisi se- FIELDS kunye ne LINES amagatya iyafana kuyo yomibini imiyalelo.Omabini amagatya ayazikhethela, kodwa ukuba omabini acacisiwe, igatya le-FIELDS kufuneka livele phambi kwe LINES igatya.

Ukuba umsebenzisi uchaza igatya le-FIELDS, amagatya alo (EKUYEKWE NGAYO, [NGOKUZITHANDELA] IVIKELWE NGU, kwaye UPHUMELELWE NGU) azikhethele, nangona kunjalo, umsebenzisi kufuneka achaze nokuba mnye kubo.

mysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl
  -> FIELDS TERMINATED BY ':'
  -> LINES TERMINATED BY '\r\n';

Ngokungagqibekanga, LOAD DATA ifaka idatha ngokolandelelwano lwemiqolo kwifayile yedatha.Ukuba iikholamu kwifayile yedatha ayihambelani namakholomu kwitheyibhile efakiweyo, kufuneka ucacise ulandelelwano lweekholomu.

Umzekelo, ulandelelwano lwekholam kwifayile yedatha ngu-a,b,c, kodwa ulandelelwano lwekholam kwitheyibhile efakelweyo ithi b,c,a, isintaksi yokungenisa idatha ngolu hlobo lulandelayo:

mysql> LOAD DATA LOCAL INFILE 'dump.txt' 
    -> INTO TABLE mytbl (b, c, a);

Ngenisa idatha usebenzisa i-mysqlimport

Umxhasi we-mysqlimport ubonelela ngojongano lomgca womyalelo kwinkcazo ye-LOAD DATA INFILEQL. Uninzi lweenketho ze-mysqlimport zihambelana ngqo negatya le-LOAD DATA INFILE.

Ukungenisa idatha kwitheyibhile yedatha yemytbl esuka kwifayile dump.txt, lo myalelo ulandelayo unokusetyenziswa:

$ mysqlimport -u root -p --local database_name dump.txt
password *****

Umyalelo we-mysqlimport ungakhankanya iinketho zokuseta ifomathi ekhankanyiweyo.

$ mysqlimport -u root -p --local --fields-terminated-by=":" \
   --lines-terminated-by="\r\n"  database_name dump.txt
password *****

Sebenzisa i --columns ukhetho kwingxelo ye-mysqlimport ukuseta ulungelelwaniso lwezintlu:

$ mysqlimport -u root -p --local --columns=b,c,a \
    database_name dump.txt
password *****

Intshayelelo kwiinketho eziqhelekileyo ze-mysqlimport

Iinketho ezisetyenziswa ngokuqhelekileyo zomyalelo we-mysqlimport zi-v ukubonisa uguqulelo (uguqulelo), -p ukwazisa igama eligqithisiweyo, njalo njalo.