public static void DeleteTable(string connectionString, string appName, string tableName)
{
MySqlAccess sqlAccess = new MySqlAccess();
string sql = string.Format("drop TABLE `{0}` ", tableName);
sqlAccess.ExecuteNonQuery(connectionString, sql, SqlProduct.MySql);
}
public static void AddBasicTable(string connectionString, string appName, string tableName)
{
MySqlAccess sqlAccess = new MySqlAccess();
string sql = string.Format("CREATE TABLE `{0}` ( " +
"`id` INT NOT NULL AUTO_INCREMENT, " +
"`name` VARCHAR(45) NULL, " +
"PRIMARY KEY (`id`));", tableName);
sqlAccess.ExecuteNonQuery(connectionString, sql, SqlProduct.MySql);
}
