如何使用MySQL将CSV文件加载到SourceStream中？

Question

我试图使用流将csv文件加载到mysql数据库表中。但是MySqlBulkLoader没有识别SourceStream的属性。我对在SourceStream中使用MySqlBulkLoader并不感到困惑。

    List<string> data= File.ReadAllLines(@"C:\mycsv.txt").ToList();

    string myConn = "Server=localhost;Database=AAAA;Uid=BBB;Pwd=CCCC";
    MySqlConnection testConn= new MySqlConnection(myConn );
    var stream = new MemoryStream()
    MySqlBulkLoader bulk = new MySqlBulkLoader(testConn)
    {
      CharacterSet = "UTF8",
      FieldQuotationCharacter = '\t',
      LineTerminator = "\r\n",
      NumberOfLinesToSkip = 1,
      TableName = "mytable",
      Local = false,
      SourceStream = stream 
      var writer = new StreamWriter(stream);   

     foreach (var d in data)
        writer.WriteLine(string.Join("\t", d));     

     writer.Flush();
     stream.Position = 0;

   }

    bulk.Load();

错误是：

MySqlBulkLoader‘不包含“SourceStream”的定义

谢谢你帮忙解决这个问题。

Answer 1

您应该设置Local=true__，它将解决这个问题。

相关文件：MySqlBulkLoader.SourceStream性质

Answer 2

使用下面的代码在代码行中将数据从S3桶加载到我的SQL

LOAD DATA FROM S3 's3://db-bucket-name/folder-name/test.csv' INTO TABLE table-name FIELDS TERMINATED BY ',' ENCLOSED BY '"+'"'+"' LINES TERMINATED BY '\r\n';