mssql 批量导入mysql_mssql 数据库批量导入指令

最新推荐文章于 2022-03-31 20:10:34 发布

圈泉

最新推荐文章于 2022-03-31 20:10:34 发布

阅读量190

点赞数

文章标签： mssql 批量导入mysql

本文链接：https://blog.csdn.net/weixin_36344862/article/details/113278832

版权

在数据库里面有一个表叫TBL_XWWL_ITEM这个表是大概结构是这样的"FLD_PID","FLD_QUESTITEM","FLD_NAME","FLD_NJ","FLD_RESIDE1","FLD_RESIDE2","FLD_SEX","FLD_DF","FLD_AT1","FLD_AT2...

在数据库里面有一个表叫 TBL_XWWL_ITEM这个表是大概结构是这样的 "FLD_PID","FLD_QUESTITEM","FLD_NAME","FLD_NJ","FLD_RESIDE1","FLD_RESIDE2","FLD_SEX","FLD_DF","FLD_AT1","FLD_AT2","FLD_LEVEL","FLD_JOB_LEVEL","FLD_ZX","FLD_MONEY","FLD_WEIGHT","FLD_TYPE","FLD_MAGIC1","FLD_MAGIC2","FLD_MAGIC3","FLD_MAGIC4","FLD_MAGIC5","FLD_DES","FLD_SIDE","ID"我想要做的是把下面这些批量导入进去100201037,0,"创心意正14刀",0,1,4,0,0,400,500,100,5,1,70000000,85,0,0,0,0,0,0,"0",0,1606

100202038,0,"创心意邪14刀",0,1,4,0,0,400,500,100,5,2,70000000,85,0,0,0,0,0,0,"0",0,1607

200201037,0,"创心意正14剑",0,2,4,0,0,350,450,100,5,1,70000000,80,0,0,0,0,0,0,"0",0,1608

200202038,0,"创心意邪14剑",0,2,4,0,0,350,450,100,5,2,70000000,80,0,0,0,0,0,0,"0",0,1609

300201037,0,"创心意正14枪",0,3,4,0,0,390,490,100,5,1,70000000,80,0,0,0,0,0,0,"0",0,1610

300202038,0,"创心意邪14枪",0,3,4,0,0,390,490,100,5,2,70000000,80,0,0,0,0,0,0,"0",0,1611 请高手指教我应该如何把下面这些导入进去呢

展开