Maitiro ekupinza txt muMySQL data tafura?Ngenisa sql faira mudhatabhesi tutori

MySQLNzira yekupinza sei data tafura mutxt?kunze sql fairaMySQL databaseTutorials

MySQL yekupinza data

Pane nzira mbiri dziri nyore dzekupinza data kunze kwenyika neMySQL muMySQL.

Pinza data uchishandisa LOAD DATA

Iyo LOAD DATA INFILE chirevo chinopihwa muMySQL yekuisa data.Muenzaniso unotevera uchaverenga faira dump.txt kubva mudhairekitori razvino uye woisa data mufaira mutafura yemytbl yedatabase iripo.

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

　Kana iyo LOCAL keyword yatsanangurwa, inoratidza kuti faira inoverengwa nenzira kubva kumutengi.Kana isina kutaurwa, iyo faira inoverengwa nenzira pane server.

Iwe unogona kutsanangura kukosha kwekoramu delimiters uye ekupedzisira-ye-mutsara mamaki zvakajeka mune iyo LOAD DATA chirevo, asi iwo akasarudzika mamaki ndeaya.Positioningmavara uye mitsara inoputika.

Syntax ye FIELDS ne LINES clauses yakafanana pamirairo miviri.Zvikamu zviviri izvi ndezvekusarudza, asi kana zvese zvatsanangurwa, chirevo cheFIELDS chinofanira kuoneka pamberi pemutsara weLINES.

Kana mushandisi akatsanangura FIELDS clause, zvinyorwa zvaro (ZVINOGARIRWA NE, [ZVINODA] ZVAKAKOMBWA NAYE, uye KUTIZWA NE) zvingasarudzwa, zvisinei, mushandisi anofanira kutsanangura chimwe chete chazvo.

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

Nekuda kwekusagadzika, LOAD DATA inoisa data muhurongwa hwemakoramu mufaira redata.Kana makoramu ari mufaira redata asingaenderane nemakoramu mutafura yakaiswa, unofanirwa kutsanangura marongero emakoramu.

Semuyenzaniso, iyo column order mu data file is a,b,c, asi column order mu table yakaiswa ndi b,c,a, data import syntax ndeiyi inotevera:

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

Ngenisa data uchishandisa mysqlimport

Iyo mysqlimport mutengi inopa yekuraira-mutsara interface kune LOAD DATA INFILEQL chirevo. Mazhinji sarudzo dze mysqlimport dzinoenderana zvakananga neiyo LOAD DATA INFILE clause.

Kupinza data mumytbl data tafura kubva pafaira dump.txt, murairo unotevera unogona kushandiswa:

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

Murairo we mysqlimport unogona kudoma sarudzo dzekuseta mafomati akataurwa.

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

Shandisa iyo --columns sarudzo mune mysqlimport chirevo kuseta kurongeka kwemakoramu:

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

Nhanganyaya kune zvakajairika sarudzo dze mysqlimport

Sarudzo dzakajairika dzemurairo we mysqlimport dzinosanganisira -v kuratidza vhezheni (vhezheni), -p kukurudzira password, zvichingodaro.