C#下Mysql的连接步骤——执行增删改语句

#因为mysql中增删改只会返回影响行数，所以在c#中其执行都可以用ExcuteNonQuery()
#如果想看插入请看上一篇文章：执行查询（select）语句

			//创建连接对象
            MySqlConnectionStringBuilder mysqlConnStr = new MySqlConnectionStringBuilder();
            mysqlConnStr.Server = "localhost";
            mysqlConnStr.UserID = "root";
            mysqlConnStr.Password = "123456";
            mysqlConnStr.Database = "test";
            
            //连接数据库
            MySqlConnection mysqlConn = new MySqlConnection(mysqlConnStr.ToString());
            mysqlConn.Open();
            //mysql添加语句--对象
            //string mysqlStrInsert = @"insert into rb_date (date) values ('2019-03-03');";
            //MySqlCommand mysqlComm = new MySqlCommand(mysqlStrInsert, mysqlConn);

            //mysql删除语句--对象
            //string mysqlStrDelete = @"delete from rb_date where date='2019-03-03';";
            //MySqlCommand mysqlComm = new MySqlCommand(mysqlStrDelete, mysqlConn);
            //mysqlComm.CommandText = mysqlStrDelete;

            //mysql修改语句--对象
            string mysqlStrUpdate = @"update rb_date set date='2019-03-03' where id=4629;";
            MySqlCommand mysqlComm = new MySqlCommand(mysqlStrUpdate, mysqlConn);
            
            int result = mysqlComm.ExecuteNonQuery();//用这个方法来执行mysql命令

            Console.WriteLine(result.ToString());
            Console.ReadLine();