mysql load data infile

標籤：檔案   cal   文字   priority   closed   current   tin   名稱   nbsp   

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ‘file_name.txt‘    [REPLACE | IGNORE]    INTO TABLE tbl_name    [FIELDS        [TERMINATED BY ‘string‘]        [[OPTIONALLY] ENCLOSED BY ‘char‘]        [ESCAPED BY ‘char‘ ]    ]    [LINES        [STARTING BY ‘string‘]        [TERMINATED BY ‘string‘]    ]    [IGNORE number LINES]    [(col_name_or_user_var,...)]    [SET col_name = expr,...)]

LOAD DATA INFILE語句用於高速地從一個文字檔中讀取行，並裝入一個表中。檔案名稱必須為一個文字字串。

 

由character_set_database系統變數指示的字元集被用於解釋檔案中的資訊。SET NAMES和character_set_client的設定不會影響對輸入的解釋。典型的樣本LOAD DATA LOCAL INFILE ‘data.txt‘ INTO TABLE tbl_name FIELDS TERMINATED BY ‘,‘ OPTIONALLY ENCLOSED BY ‘"‘ LINES TERMINATED BY ‘\n‘如果您只想載入一個表的部分列，則應指定一個列清單：LOAD DATA LOCAL INFILE ‘persondata.txt‘ INTO TABLE persondata (col1,col2);

 

mysql load data infile