Mysql的大量匯入類 MySqlBulkLoader

標籤：name   car   應該   5.7   connect   sql   value   for   字元   

在mssqlserver 中 對應的SqlBuckCopy類，進行批量資料插入。

在mysql 中，官方提供了MySqlBulkLoader 平行的工具；

不過裡面有坑，具體坑是插入空值列 NULL的。

 

For input, if the FIELDS ESCAPED BY character is not empty, occurrences of that character are stripped and the following character is taken literally as part of a field value. Some two-character sequences that are exceptions, where the first character is the escape character. These sequences are shown in the following table (using \ for the escape character). The rules for NULLhandling are described later in this section.

Character	Escape Sequence
\0	An ASCII NUL (X‘00‘) character
\b	A backspace character
\n	A newline (linefeed) character
\r	A carriage return character
\t	A tab character.
\Z	ASCII 26 (Control+Z)
\N	NULL

 

在 MySql.Data.dll 提供的驅動中，使用 \N  字元並未將NULL列插入。應該使用關鍵詞 NULL  進行空值的代表。

 

 //tran = conn.BeginTransaction();                      MySqlBulkLoader bulk = new MySqlBulkLoader(conn)                      {                          FieldTerminator = ",",                          FieldQuotationCharacter = ‘"‘,                          EscapeCharacter = ‘"‘,                          LineTerminator = "\r\n",                          FileName = tmpPath,                          NumberOfLinesToSkip = 0,                          TableName = table.TableName,                      };                      //bulk.Columns.AddRange(table.Columns.Cast<DataColumn>().Select(colum => colum.ColumnName).ToArray());                      insertCount = bulk.Load();  

　　

具體資料：

https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html

https://dev.mysql.com/doc/refman/5.7/en/load-data.html

http://blog.csdn.net/zhou2s_101216/article/details/50875211

https://dev.mysql.com/doc/refman/5.7/en/load-data.html

 

Mysql的大量匯入類 MySqlBulkLoader