如何在c#中获取MYSQL数据库名称、表、列和行

using MySql.Data.MySqlClient;

string connectionString = "server=服务器地址;user id=用户名;password=密码;database=数据库名称";

using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();
    // 在此处执行数据库操作
}

string query = "SHOW DATABASES";
using (MySqlCommand command = new MySqlCommand(query, connection))
{
    using (MySqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            string databaseName = reader.GetString(0);
            // 处理数据库名称
        }
    }
}

string query = "SHOW TABLES";
using (MySqlCommand command = new MySqlCommand(query, connection))
{
    using (MySqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            string tableName = reader.GetString(0);
            // 处理表名称
        }
    }
}

string query = "SHOW COLUMNS FROM 表名";
using (MySqlCommand command = new MySqlCommand(query, connection))
{
    using (MySqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            string columnName = reader.GetString(0);
            // 处理列名称
        }
    }
}

string query = "SELECT * FROM 表名";
using (MySqlCommand command = new MySqlCommand(query, connection))
{
    using (MySqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            // 处理每一行的数据
        }
    }
}