摘要:更新、新增、刪除MySQL資料庫資料語法
//引用MySQL套件參考using MySql.Data.MySqlClient;//資料庫位址MySqlConnection myConnection = new MySqlConnection("server=資料庫IP;user id=資料庫使用者帳號; password=帳號的密碼; database=資料庫名稱; CharSet=utf8");//開啟資料庫myConnection.Open();/*更新*/string update = string.Format("update 資料表 set 欄位1='{0}', 欄位2='{1}'", 值1,值2);MySqlCommand updateCmd = new MySqlCommand(update, myConnection);updateCmd.Connection = myConnection;//執行更新updateCmd.ExecuteNonQuery();/*新增*/string AddNew = string.Format("INSERT INTO 資料表(欄位1, 欄位2) VALUES('{0}','{1}')", 值1, 值2);MySqlCommand AddNewCmd = new MySqlCommand(AddNew, myConnection);AddNewCmd.Connection = myConnection;//執行新增AddNewCmd.ExecuteNonQuery();/*刪除*/string Del = string.Format("DELETE FROM 資料表 WHERE 欄位 = '{0}'", 值);MySqlCommand DelCmd = new MySqlCommand(Del, myConnection);DelCmd.Connection = myConnection;//執行刪除DelCmd.ExecuteNonQuery();//關閉資料庫myConnection.Close();