Mysql的批量导入类 MySqlBulkLoader

 //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

标签：name   car   应该   5.7   connect   sql   value   for   字符