public void DropTable()
{
try
{
var mysql = new eMySQL("test");
string query = "DROP TABLE test;";
mysql.ExecuteNoneQuery(query);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
public void CreateTable()
{
try
{
var mysql = new eMySQL("test");
string query = "CREATE TABLE test (c CHAR(20) CHARACTER SET utf8 COLLATE utf8_bin);";
//excute
mysql.ExecuteNoneQuery(query);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
public void CreateDatabase()
{
try
{
var mysql = new eMySQL();
string query = "CREATE DATABASE test;";
mysql.ExecuteNoneQuery(query);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
public void SelectWithError()
{
try
{
var mysql = new eMySQL();
string query = "SELECT NNOW()";
Debug.WriteLine("Executing query: {0}", query);
var result = mysql.ExecuteQuery(query);
foreach (var item in result)
{
Debug.WriteLine(string.Join(",", item));
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
