U ka kenya txt joang tafoleng ea data ea MySQL?Kenya faele ea sql ho thupelo ea database

MySQLU ka kenya tafole ea data joang ho txt?kenya faele ea sqlMySQL databaseThutong

Lintlha tse tsoang ho MySQL

Ho na le mekhoa e 'meli e bonolo ea ho kenya data e rometsoeng ke MySQL ho MySQL.

Kenya data ka LOAD DATA

Polelo ea LOAD DATA INFILE e fanoe ho MySQL ho kenya data.Mohlala o latelang o tla bala faele dump.txt ho tsoa bukeng ea hajoale ebe o kenya lintlha tse faeleng tafoleng ea mytbl ea database ea hajoale.

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

　Haeba LOCAL keyword e hlalositsoe, e bontša hore faele e baloa ka tsela e tsoang ho mofani oa bareki.Haeba e sa hlalosoa, faele e baloa ka tsela ho seva.

O ka hlakisa li-delimiter tsa boleng ba kholomo le matšoao a ho qetela ka ho hlaka ho LOAD DATA statement, empa matšoao a kamehla keBoemobaphetwa le dikgaohano tsa mela.

Polelo ya polelo ya FIELDS le LINES e a tshwana bakeng sa ditaelo ka bobedi.Lipolelo ka bobeli ke tsa boikhethelo, empa haeba ka bobeli li hlalositsoe, poleloana ea FIELDS e tlameha ho hlaha pele ho karolo ea LINES.

Haeba mosebelisi a hlakisa karoloana ea FIELDS, lipehelo tsa eona (E TERMINATED BY, [KA BOIkhethelo] E TSOILWE KE, 'me E ESCAPED BY) ke boikhethelo, leha ho le joalo, mosebelisi o tlameha ho bolela bonyane e le 'ngoe ea tsona.

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

Ka tloaelo, LOAD DATA e kenya data ka tatellano ea likholomo faeleng ea data Haeba likholomo tse faeleng ea data li sa lumellane le likholomo tse tafoleng e kentsoeng, u lokela ho hlakisa tatellano ea litšiea.

Mohlala, tatellano ea kholomo faeleng ea data ke a,b,c, empa tatellano ea kholomo tafoleng e kentsoeng ke b,c,a, syntax ea ho kenya data e tjena:

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

Kenya data u sebelisa mysqlimport

Moreki oa mysqlimport o fana ka sebopeho sa mola oa taelo ho polelo ea LOAD DATA INFILEQL. Bongata ba likhetho tsa mysqlimport li lumellana ka kotloloho le poleloana ea LOAD DATA INFILE.

Ho kenya data ho tafole ea data ea mytbl ho tsoa ho file dump.txt, ho ka sebelisoa taelo e latelang:

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

Taelo ea mysqlimport e ka hlakisa likhetho tsa ho seta sebopeho se boletsoeng.

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

Sebelisa khetho ea --columns polelong ea mysqlimport ho hlophisa tatellano ea likholomo:

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

Kenyelletso ea likhetho tse tloaelehileng tsa mysqlimport

Likhetho tse sebelisoang hangata tsa taelo ea mysqlimport ke -v ho bonts'a mofuta (phetolelo), -p ho khothaletsa phasewete, joalo-joalo.