Otu esi ebubata txt n'ime tebụl data MySQL?Bubata sql faịlụ n'ime nkuzi nchekwa data

Kedu otu esi ebubata faịlụ TXT na tebụl MySQL ? Nkuzi gbasara ibubata faịlụ SQL na nchekwa data MySQL.

MySQL mbubata data

Enwere ụzọ abụọ dị mfe iji bubata data nke MySQL na-ebupụ na MySQL.

Jiri LOAD DATA bubata data

Enyere nkwupụta LOAD DATA INFILE na MySQL iji tinye data.Ihe atụ na-esonụ ga-agụ faịlụ dump.txt site na ndekọ ugbu a ma tinye data na faịlụ ahụ n'ime tebụl mytbl nke nchekwa data dị ugbu a.

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

　Ọ bụrụ na akọwapụtara isiokwu LOCAL, ọ na-egosi na a na-agụ faịlụ ahụ site n'ụzọ site n'aka onye ahịa ahịa.Ọ bụrụ na akọwapụtaghị ya, a na-agụ faịlụ ahụ site n'ụzọ na sava ahụ.

I nwere ike ịkọwapụta nke ọma ihe nkesa uru kọlụm na ihe nrịbama njedebe ahịrị na nkwupụta LOAD DATA, mana ihe nrịbama ndabara bụ arịlịka na ahịrị ọhụrụ.

Njikọ nke ngalaba FIELDS na LINES bụ otu maka iwu abụọ ahụ.Nkeji edemede abụọ a bụ nhọrọ, mana ọ bụrụ na akọwapụtara ha abụọ, akụkụ FIELDS ga-apụtarịrị n'ihu nkebi ahịrịokwu LINES.

Ọ bụrụ na onye ọrụ ezipụta nkebiokwu ubi, nkebiokwu ya ( NDỊ KWESỊRỊTA, [NHỤRỤ] ECHICHE, na ESCAPED BY) bụ nhọrọ, agbanyeghị, onye ọrụ ga-ezipụta opekata mpe otu n'ime ha.

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

Site na ndabara, LOAD DATA na-etinye data n'usoro nke kọlụm dị na faịlụ data Ọ bụrụ na kọlụm dị na faịlụ data ekwekọghị na kọlụm dị na tebụl etinyere, ịkwesịrị ịkọwa usoro nke kọlụm.

Dịka ọmụmaatụ, usoro kọlụm dị na faịlụ data bụ a,b,c, mana usoro kọlụm dị na tebụl etinyere bụ b,c,a, syntax mbubata data bụ nke a:

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

Iji mysqlimport bubata data

Onye ahịa mysqlimport na-enye interface ahịrị iwu na nkwupụta LOAD DATA INFILEQL. Ọtụtụ nhọrọ nke mysqlimport dabara na nkebiokwu LOAD DATA INFILE.

Iji bubata data n'ime tebụl data mytbl site na faịlụ dump.txt, enwere ike iji iwu a:

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

Iwu mysqlimport nwere ike ịkọwapụta nhọrọ iji tọọ usoro akọwapụtara. Usoro nkwupụta iwu ahụ bụ nke a:

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

Jiri nhọrọ --columns dị na nkwupụta mysqlimport ka ịtọ usoro nke kọlụm:

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

Okwu mmalite nke nhọrọ a na-ahụkarị nke mysqlimport

Nhọrọ ndị a na-ejikarị nke mysqlimport iwu bụ -v iji gosipụta ụdị (ụdị), -p iji mee ka okwuntughe, na ihe ndị ọzọ.