所谓查询单个数据指的是查询的数据中只有一行一列

using System;
using MySql.Data.MySqlClient;

namespace Mysql_Conn
{
    class Program
    {
        static void Main(string[] args)
        {
            string conStr = "server=127.0.0.1;port=3306;database=chicai_note;user=root;password=";
            MySqlConnection conn = new MySqlConnection(conStr);
            try
            {
                conn.Open();
                string countSql = "select count(*) from chicai_config";
                MySqlCommand countCom = new MySqlCommand(countSql, conn);
                object res = countCom.ExecuteScalar();//直接获取到要的数据
                Console.WriteLine(res.ToString());
            }
            catch (Exception e) {
                Console.WriteLine(e.ToString());
            }

            Console.ReadKey();
        }
    }
}
C#

使用MysqkCommand的ExecuteScalar()方法直接获取到想要的那一个数据