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);
}
}
