C# mysql增删改查

 先加入依赖MySql.Data 6.8.8 

创建好数据库及表

 public void MysqlTest()
        {
            string myConnectionString = "Server = localhost; UserId = root; Password = 123456; Database = ft_m20;pooling=false;charset=utf8";
            try
            {
                conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);               
                conn.Open();
                Log("mysql连接成功");


                //增
                string sql3 = "insert into ft_imei (imei,state) values ('IMEI00001','1')";
                MySqlCommand cmd3 = new MySqlCommand(sql3, conn);
                int rows = cmd3.ExecuteNonQuery();
                Log("mysql插入影响行数"+rows);

                //改
                string sql5 = "update ft_imei set state=0";
                MySqlCommand cmd5 = new MySqlCommand(sql5, conn);
                int rows5 = cmd5.ExecuteNonQuery();
                Log("mysql修改影响行数" + rows5);

     
                //查
                string sql4 = "select * from ft_imei";
                MySqlCommand cmd4 = new MySqlCommand(sql4, conn);
                MySqlDataReader r= cmd4.ExecuteReader();
                Log("mysql查询" );
                while (r.Read())
                {
                    Log(""+ r[0]+" "+r[1]);
                }
                r.Close();

                //删
                string sql6 = "delete from ft_imei where state=0";
                MySqlCommand cmd6 = new MySqlCommand(sql6, conn);
                int rows6 = cmd6.ExecuteNonQuery();
                Log("mysql删除影响行数" + rows6);



                conn.Close();
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                Log(ex.Message);
            }
        }