c#连接mysql数据库进行简单操作

using System;
using MySql.Data.MySqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "server=<MySQL服务器地址>;user=<用户名>;database=<数据库名>;password=<密码>";

        MySqlConnection connection = new MySqlConnection(connectionString);

        try
        {
            connection.Open();

            // 执行查询
            string query = "SELECT * FROM <表名>";
            MySqlCommand command = new MySqlCommand(query, connection);

            MySqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine(reader["<列名>"]);
            }
            reader.Close();

            // 执行插入
            string insertQuery = "INSERT INTO <表名> VALUES (<值>)";
            MySqlCommand insertCommand = new MySqlCommand(insertQuery, connection);
            insertCommand.ExecuteNonQuery();

            // 执行更新
            string updateQuery = "UPDATE <表名> SET <列名> = <值> WHERE <条件>";
            MySqlCommand updateCommand = new MySqlCommand(updateQuery, connection);
            updateCommand.ExecuteNonQuery();

            // 执行删除
            string deleteQuery = "DELETE FROM <表名> WHERE <条件>";
            MySqlCommand deleteCommand = new MySqlCommand(deleteQuery, connection);
            deleteCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        finally
        {
            connection.Close();
        }
    }
}