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