![301免备案跳转微信公众号 301免备案跳转微信公众号](/blog/d/file/p/2023/11-06/384a0f88dc69e6f0b9276fec739fb818.png)
![腾讯云服务器大促销。](/blog/d/file/p/2023/06-06/8f2af9e8846e4a93cc2a3890462510dc.png)
![华为服务器](/blog/d/file/p/2023/07-25/08518ffe66f6cea5a59993d8b8d33b96.jpg)
![](/blog/d/file/p/2020/06-18/67392b71e6ac744ad8047a2e60db98f7.jpg)
分析:分析发现,该表中除开bianhao及 qrcode 字段不一样外,其他字段都一样,bianhao字段内容对应qrcode 后面内容,如图
![](/blog/d/file/p/2020/06-18/dcb3fbd4d08697c1bdb1488883dfca0c.jpg)
域名用想起可将这些内容放在C#数组中,然后在遍历数组生成具体sql语句,在将语句导入即可.最终问题解决。
代码如下
生成的sql如下:using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
namespace ConsoleApp3
{
class Program
{
static void Main(string[] args)
{
string C;
long[] bianhao = new long[] { 2123123132231,5456465456,545645646,456456465 }; //若数据较大,可直接从txt文件中读取
for (long i = 0; i < bianhao.Length; i++)
{
C = "INSERT INTO `az522`.`tgs_code` (`id`, `bianhao`, `riqi`, `product`, `zd1`, `zd2`, `tupian`, `jianjie`, `qrcode`, `hits`, `query_time`) VALUES('', '" + bianhao[i] + "', '2020-12-31', 'AZ第一批', '--', '--', 'http://www.zfcdn.xyz//upload/nopic.jpg', '', 'http://www.zfcdn.xyz//qrcode.php?bianhao=" + bianhao[i]+ "', '0', NULL);"+"\n";
using (StreamWriter sw = new StreamWriter(@"d:\sql.txt", true)) //将sql语句生成到sql.txt中
{
sw.WriteLine(C); //追加写入。
}
}
}
}
}
![](/blog/d/file/p/2020/06-18/6e144676ce6ce8084e26832a07b2cc5b.jpg)
在navicat中导入成功:
![](/blog/d/file/p/2020/06-18/91e3221cb16f4a6cb468dcaa585f60da.jpg)
![301免备案跳转微信公众号 301免备案跳转微信公众号](/blog/d/file/p/2023/11-06/384a0f88dc69e6f0b9276fec739fb818.png)
![华为服务器](/blog/d/file/p/2023/07-25/08518ffe66f6cea5a59993d8b8d33b96.jpg)
![腾讯云服务器大促销。](/blog/d/file/p/2023/06-06/8f2af9e8846e4a93cc2a3890462510dc.png)
文章评论 本文章有个评论