201711122245->mysql库删除一条数据

目的:删除一条数据

详细代码:

            string sqlconst = "server=localhost;user=root;database=mytestsql;port=3306;password=root;";
            MySqlConnection connect = new MySqlConnection(sqlconst);
            connect.Open();
            Console.WriteLine("成功链接mysql...");

            MySqlCommand command = new MySqlCommand("delete from testuserid where id=100003", connect);
            try
            {
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine("删除数据失败...");
            }

            connect.Close();