如何将大量数据插入mysql数据库？ [英] How to insert large amount of data into mysql database?

问题描述

大家好，

i有视觉工作室2012 winform c＃。



来自我的winform c＃我想插入大量数据我的数据库（Mysql）。

i使用MySqlTransaction，但分辨率太慢。



如何使我的代码有效，以减少分辨率时间和制作插入更快？



我尝试过：

Hi all,
i have visual studio 2012 winform c#.

from my winform c# i want to insert large amount if data in my database(Mysql).
i used MySqlTransaction but it the resolution is too slow.

How can i make my code effecient such that to reduce the resolution time and make the insertion faster?

What I have tried:

DataTable dchild = new DataTable();

 DataRow[] drchild = dchild.Select("request_number >0");
            string qry = "INSERT ignore INTO medicine_jhatpat.childs_report (R_Nber_Id,Society_Name,Service_Category,Service_Type,code) VALUES(@rn,@sn,@sc,@st,@pc) ;";
            using (MySqlConnection conn_child = new MySqlConnection(strcon))
            {
                conn_child.Open();
                using (MySqlTransaction trans = conn_child.BeginTransaction())
                {
                    using (MySqlCommand cmd_child = new MySqlCommand(qry, conn_child, trans))
                    {

                        cmd_child.CommandType = CommandType.Text;
                        foreach (var item in drchild)
                        {

                            cmd_child.Parameters.Clear();
                            cmd_child.Parameters.AddWithValue("@rn", item["request_number"]);
                            cmd_child.Parameters.AddWithValue("@sn", item["city"]);
                            cmd_child.Parameters.AddWithValue("@sc", item["service_category"]);
                            cmd_child.Parameters.AddWithValue("@st", item["service_type"]);
                            cmd_child.Parameters.AddWithValue("@pc", item["pincode"]);

                            cmd_child.ExecuteNonQuery();
                        }
                        trans.Commit();
                    }
                }
            }

推荐答案

MySQL具有批量插入功能。阅读此处 [ ^ ]。

MySQL has a "bulk insert" capability. Read up on it here[^].

这篇关于如何将大量数据插入mysql数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！