Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

针对大批数据插入时,需要针对mysql,mssql增加批量插入方法 #61

Open
jiangsz888 opened this issue Feb 28, 2020 · 0 comments

Comments

@jiangsz888
Copy link

针对mysql
有批量数据插入时,需要利用mysql的批量插入特性
例:insert into user(usercode,username)values
('001','张三'),
('002','李四'),
('003','王伍'),
('004','李白')

针对sql server
可偿试如下两种方式,以下方式在ado.net 中性能很高,不确定go中是否好实现
sql bulk copy
sql bulk insert

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant