yoku0825��
��

��
��C#��
��yoku0825��

��
MySQL��Connector��
��

��
while(File.Exists())��
��
��INTO OUTFILE��
��While��File.Delete��
��.NET��File.Delete��
��Connector��

------------------------------------
using System;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

private void test_ctrl()
{
string host = "host_name";
string user = "userID";
string pass = "password";
string schema = "mysql";
string conString = "SERVER=" + host + ";"
+ "DATABASE=" + schema + ";"
+ "UID=" + user + ";"
+ "PASSWORD=" + pass + ";";
MySqlConnection myConnect = new MySqlConnection(conString);
myConnect.Open();

string testDir = @"\\" + host + @"\TEST\";
string testFileName = "test.tsv";
string testFullPath_Out = System.IO.Path.Combine(testDir, testFileName);
string testFullPathI_IN = @"D:\\TEST\\" + testFileName;
string SQL = @"SELECT * FROM mysql.db LIMIT 1"
+ " INTO OUTFILE '" + testFullPathI_IN + @"' FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'";
for (int i = 0; i < 1000; i++)
{
if (System.IO.File.Exists(testFullPath_Out))
{
System.IO.File.Delete(testFullPath_Out);
}
using (MySqlCommand myCommand = new MySqlCommand(SQL, myConnect))
{
try
{
myCommand.ExecuteNonQuery();
}
catch (MySqlException myEx)
{
MessageBox.Show(myEx.ToString()); //100��Already Exists��
}
myCommand.Dispose();
}
Console.WriteLine(i.ToString());
}
MessageBox.Show("��");
myConnect.Close();
myConnect.Dispose();
}

(2014/12/14 23:35), yoku ts. wrote:

��yoku0825��

��

>---��---

> ��VS2012��
> ��File.Delete��INTO OUTFILE��Sleep��5��

�� (?)��File.Exists��TRUE��

��INTO OUTFILE��File.Delete(File.Exists)��

1. ��

2. ��

3. SELECT .. INTO OUTFILE ..

-- �� --

4. ��

5. ��

6. SELECT .. INTO OUTFILE ..

��OS��File.Exists��FALSE��

��(File.Delete��File��)��

OS��mysqld��

5.0��5.6��select_export::prepare��create_file��(�� )��

��

yoku0825,

2014��12��12�� 14:22 �� <atsushi.shizawa@seikodo.co.jp>:
��
��

MySQLWindows��
��

---��---
OS ��Windows2012 Std(Memory24GB)
DB ��MySQL 5.6.21
Coccector ��Net 6.9.5
FrameWork ��.NET FrameWork 4.5
IDE ��VS2012 Pro

---��---
��INTO OUTFILE ��File.Delete��
��IF(File.Exists==TRUE){File.Delete}��
SQL��MySqlException��

��1086��already exists��

��OS��

---��---
��VS2012��
��File.Delete��INTO OUTFILE��Sleep��5��
��Win2008R2��
��CentOS��
��MySQL5.5��
--��--
��MySQL5.0��

��
DB��Connector��OS��
��