Home >Database >Mysql Tutorial >sqlserver 批量插入
sqlserver 批量插入
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 15:39:371099browse
我写点伪代码： private InsertData(){ var StartId = exec("select max(id) from table1"); for(var i =1;i10;i++){ exec("insert Table1(Name) values('Name"+i.ToString()+"')") } var EndId = exec("select max(id) from table1"); for(var i =StartId;i
我写点伪代码：
private InsertData(){
var StartId = exec("select max(id) from table1");
for(var i =1;i
exec("insert Table1(Name) values('Name"+i.ToString()+"')")
}
var EndId = exec("select max(id) from table1");
for(var i =StartId;i
exec("insert Table2(MainId) values('"+i.ToString()+"')")
}
}
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql的安装与设置记录Next article：NetBeans IDE 与 MySQL 5.6连接