Mysql BulkCopy
来源:互联网 发布:sql中怎么设置外键 编辑:程序博客网 时间:2024/06/05 00:57
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
try
{
conn.Open();
//tran = conn.BeginTransaction();
MySqlBulkLoader bulk = new MySqlBulkLoader(conn)
{
FieldTerminator = ",",
FieldQuotationCharacter = '"',
EscapeCharacter = '"',
LineTerminator = @"\n",
FileName = filePath,
NumberOfLinesToSkip = 1,
TableName = "ips"
};
//bulk.Columns.AddRange(table.Columns.Cast<DataColumn>().Select(colum => colum.ColumnName).ToArray());
int count= bulk.Load();
Console.WriteLine(count + " lines uploaded.");
Console.WriteLine("time cast" + sw.Elapsed);
// tran.Commit();
}
{
try
{
conn.Open();
//tran = conn.BeginTransaction();
MySqlBulkLoader bulk = new MySqlBulkLoader(conn)
{
FieldTerminator = ",",
FieldQuotationCharacter = '"',
EscapeCharacter = '"',
LineTerminator = @"\n",
FileName = filePath,
NumberOfLinesToSkip = 1,
TableName = "ips"
};
//bulk.Columns.AddRange(table.Columns.Cast<DataColumn>().Select(colum => colum.ColumnName).ToArray());
int count= bulk.Load();
Console.WriteLine(count + " lines uploaded.");
Console.WriteLine("time cast" + sw.Elapsed);
// tran.Commit();
}
0 0
- Mysql BulkCopy
- SQL "SELECT INTO/BULKCOPY" 的用法
- C# BulkCopy方式数据批量导入数据库
- BulkCopy from source table to destination table with a column whose type is different
- Oracle数据库学习小结(三)---大数据批量插入bulkcopy
- Mysql
- MySql
- MYSQL
- MySQL
- mysql
- mysql
- mysql
- mysql
- Mysql
- Mysql
- mysql
- MySQL
- mysql
- 素数判断算法(高效率)
- gerrit 在win7下安装总结
- Ubuntu14.04登录的时候,如何选择root登录问题
- Hdu-5763 Another Meaning(DP+KMP)
- 文章标题
- Mysql BulkCopy
- 题目243 交换输出
- php的简单使用
- Easyui,Echart,Jsp+Servlet开发简单完整实例
- Nginx的安装和配置
- APP进入后台程序运行终止
- MySQL set autocommit = 0或1分别什么啊,哪个是自动提交啊
- 学习笔记之C#基础知识--String
- 马踏棋盘算法(骑士周游问题)