C# MySQL无法从一个表中提取数据并添加到另一个表中

using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "server=localhost;database=mydatabase;uid=username;password=password;";
        
        // 连接到MySQL数据库
        using (var connection = new MySqlConnection(connectionString))
        {
            connection.Open();
            
            // 执行查询语句
            string query = "SELECT * FROM table1;";
            using (var command = new MySqlCommand(query, connection))
            {
                using (var reader = command.ExecuteReader())
                {
                    // 获取查询结果
                    while (reader.Read())
                    {
                        // 读取每一行数据
                        int id = reader.GetInt32("id");
                        string name = reader.GetString("name");
                        
                        // 插入数据到另一个表中
                        string insertQuery = $"INSERT INTO table2 (id, name) VALUES ({id}, '{name}');";
                        using (var insertCommand = new MySqlCommand(insertQuery, connection))
                        {
                            insertCommand.ExecuteNonQuery();
                        }
                    }
                }
            }
        }
    }
}