mysql 数据库取出字段md5加密后形成新字段再插入

INTO `permeationdomain` VALUES (‘10000.ys.51juban.com‘, ‘282‘, ‘superman‘, ‘2020-01-06 08:54:28‘, null, null, null, null, null, null); INSERT INTO `permeationdomain` VALUES (‘5198.alog.com‘, ‘282‘, ‘superman‘, ‘2020-01-06 08:54:28‘, null, null, null, null, null, null); INSERT INTO `permeationdomain` VALUES (‘51juban.com‘, ‘282‘, ‘superman‘, ‘2020-01-06 08:54:28‘, null, null, null, null, null, null); INSERT INTO `permeationdomain` VALUES (‘admin.juban.com‘, ‘282‘, ‘superman‘, ‘2020-01-03 11:06:05‘, null, null, null, null, null, null); INSERT INTO `permeationdomain` VALUES (‘alog.com‘, ‘282‘, ‘superman‘, ‘2020-01-06 08:54:27‘, null, null, null, null, null, null); INSERT INTO `permeationdomain` VALUES (‘alogoms.cangyibao.com‘, ‘282‘, ‘superman‘, ‘2020-01-06 08:54:27‘, null, null, null, null, null, null);

进行修改

<span style="color: #008000;">#</span><span style="color: #008000;"> -*- coding: utf-8 -*-</span>
<span style="color: #0000ff;">import</span><span style="color: #000000;"> json
</span><span style="color: #0000ff;">import</span><span style="color: #000000;"> codecs
</span><span style="color: #0000ff;">import</span><span style="color: #000000;"> hashlib
</span><span style="color: #0000ff;">from</span> datetime <span style="color: #0000ff;">import</span><span style="color: #000000;"> datetime
with open(</span><span style="color: #800000;">"</span><span style="color: #800000;">permeationdomain.sql</span><span style="color: #800000;">"</span>, <span style="color: #800000;">"</span><span style="color: #800000;">r</span><span style="color: #800000;">"</span>,encoding= <span style="color: #800000;">"</span><span style="color: #800000;">utf-8</span><span style="color: #800000;">"</span><span style="color: #000000;">) as f:
    flist </span>=<span style="color: #000000;"> f.read()
    </span><span style="color: #0000ff;">for</span> i <span style="color: #0000ff;">in</span> flist.split(<span style="color: #800000;">"</span><span style="color: #800000;">\n</span><span style="color: #800000;">"</span><span style="color: #000000;">):
        </span><span style="color: #0000ff;">if</span><span style="color: #000000;"> i:
            everyone </span>= i.split(<span style="color: #800000;">"</span><span style="color: #800000;">VALUES</span><span style="color: #800000;">"</span><span style="color: #000000;">)
            data </span>= everyone[1][:-1<span style="color: #000000;">]
            data </span>= data.replace(<span style="color: #800000;">‘</span><span style="color: #800000;">null</span><span style="color: #800000;">‘</span>, <span style="color: #800000;">‘</span><span style="color: #800000;">"null"</span><span style="color: #800000;">‘</span><span style="color: #000000;">)
            tupdata </span>=<span style="color: #000000;"> eval(data)
            hashl </span>=<span style="color: #000000;"> hashlib.md5()
            hashl.update(tupdata[0].encode(</span><span style="color: #800000;">"</span><span style="color: #800000;">utf-8</span><span style="color: #800000;">"</span><span style="color: #000000;">))
            md5</span>=<span style="color: #000000;">hashl.hexdigest()
            listdata </span>=<span style="color: #000000;"> list(tupdata)
            listdata.insert(0, md5)
            date </span>=<span style="color: #000000;"> datetime.now()
            </span><span style="color: #0000ff;">if</span> listdata[4] == <span style="color: #800000;">"</span><span style="color: #800000;">null</span><span style="color: #800000;">"</span><span style="color: #000000;">:
                listdata[</span>4] =<span style="color: #000000;"> str(datetime.now())
            dataall </span>= everyone[0] + <span style="color: #800000;">"</span><span style="color: #800000;">VALUES</span><span style="color: #800000;">"</span> + str(tuple(listdata)) + <span style="color: #800000;">"</span><span style="color: #800000;">;</span><span style="color: #800000;">"</span><span style="color: #000000;">
            with codecs.open(</span><span style="color: #800000;">"</span><span style="color: #800000;">per.sql</span><span style="color: #800000;">"</span>, <span style="color: #800000;">"</span><span style="color: #800000;">a</span><span style="color: #800000;">"</span>, <span style="color: #800000;">"</span><span style="color: #800000;">utf-8</span><span style="color: #800000;">"</span><span style="color: #000000;">) as f:
                f.write(dataall</span>+ <span style="color: #800000;">"</span><span style="color: #800000;">\n</span><span style="color: #800000;">"</span>)

最后插入表的sql语句

<span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">007cfbcec99a649d9e759c66be03e305</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">http://www.czdx.gov.cn/</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">217001002</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">superman</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2019-12-18 09:09:19</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">滁州市</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">0092ca6c575186e64ff53b477ee0d85b</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">http://www.bai.gov.cn/</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">217001</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">superman</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2019-12-17 17:29:07</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">北京</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">00b4509e1e3cb17dd5e2db7ce82d7e42</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">http://www.js.xinhuanet.com/</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">051004</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">guozk</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2019-12-18 14:07:34</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">江苏</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">00e17b3c96289daff5fa30967d20a4cc</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">test.alog.cc</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">282</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">superman</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2020-01-06 08:53:30</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">00e6890bd2c99baaf5b556c6f97b2df0</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">http://www.ccps.gov.cn/bmpd/jsjxxy2/</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">217</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">superman</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2019-12-17 16:49:23</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">下设部门-全国党校（行政学院）教师进修学院</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">00eb8b07656ea5a3c362dc8e381b6d23</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">http://202.84.17.254/</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">051007</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">guozk</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2020-01-06 11:07:32</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">图片上传系统</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">022be146e00a5673b8b73c60a2b82e7a</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">https://wp.xinhua-news.cn/ssologin/</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">051007</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">guozk</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2020-01-06 11:01:21</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">新华社云存储登陆</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> `permeationdomain` <span style="color: #0000ff;">VALUES</span> (<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">0292731fcab7e7004fc377d4d72a41ec</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">http://www.qhswdx.com/index.jsp</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">217001</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">superman</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">2019-12-17 17:29:07</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">青海</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>, <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">null</span><span style="color: #ff0000;">‘</span>);

mysql 数据库取出字段md5加密后形成新字段再插入

标签：with   http   青海   图片上传   str   data   com   index   部门