c#控制mysql数据库

using MySql.Data.MySqlClient;

// 建立连接
string connectionString = "server=localhost;user=root;password=123456;database=mydb;";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();

    // 执行查询语句
    string query = "SELECT * FROM users";
    using (MySqlCommand command = new MySqlCommand(query, connection))
    {
        using (MySqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 处理查询结果
                string username = reader.GetString("username");
                int age = reader.GetInt32("age");
                // ...
            }
        }
    }

    // 执行插入语句
    string insertQuery = "INSERT INTO users (username, age) VALUES (@username, @age)";
    using (MySqlCommand command = new MySqlCommand(insertQuery, connection))
    {
        command.Parameters.AddWithValue("@username", "John");
        command.Parameters.AddWithValue("@age", 25);
        int affectedRows = command.ExecuteNonQuery();
        // 处理插入结果
    }

    // 其他操作...
}