C# 操作mysql-创建表、插入更新数据

最新推荐文章于 2025-07-09 09:54:27 发布

原创

最新推荐文章于 2025-07-09 09:54:27 发布 · 6.8k 阅读

20 ·

CC 4.0 BY-SA版权

需要做一个项目，里边涉及对mysql表的简单操作，下边是代码

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading;
using System.Threading.Tasks;
using TPI;

namespace KeyWordStatistic
{
    public class ChinessKeyWordStatistic
    {
        string connectMysql = "server = 192.168.*****"
               + "; database = Test"
               + "; user id = ****"
               + "; password = *****"
               + ";pooling=true;CharSet=utf8;port=3306;SslMode = none;";

        string mysqltableName = "ChinesekeyWordsCnts";
        public void NewThread()
        {
            CreatedMysqlTable();
            var Dic = new Dictionary<string, int>();
            //添加Dic数据
            var sql = "INSERT IGNORE INTO t_ck VALUE(?k,?cnt)";
            var j = 0;
            foreach (var kv in Dic)
            {
                j += MySqlHelper.E