现在有一批md5,保存为1.txt,如下:21232f297a57a5a743894a0e4a801fc3
7fef6171469e80d32c0559f88b377245
63a9f0ea7bb98050796b649e85481845
eb0a191797624dd3a48fa681d3061212
将他们解密后得到结果保存为 2.txt,格式如下:21232f297a57a5a743894a0e4a801fc3 admin
7fef6171469e80d32c0559f88b377245 admin888
63a9f0ea7bb98050796b649e85481845 root
eb0a191797624dd3a48fa681d3061212 master
现在我想将1.txt里面的内容替换为2.txt。目前软件市面上的软件无法实现这种效果其一:遇到1,txt里的
21232f297a57a5a743894a0e4a801fc3将他替换为
21232f297a57a5a743894a0e4a801fc3 admin如果没有遇到,就跳过,以此类推------------------------------
想通过mysql实现这一效果,环境:PHPnow-1.5.6,MYsql版本5.0使用软件:Navicat Premium数据库字符串:gb2312 -- GB2312 Simplified Chinese
排序规则:gb2312_chinese_ci字段类型统一为:text,编码utf8
目前个人思路如下:讲纯md5导入md5字段1讲解密后的结果导入pass字段2然后通过语句,将字段1里的内容替换为字段2
7fef6171469e80d32c0559f88b377245
63a9f0ea7bb98050796b649e85481845
eb0a191797624dd3a48fa681d3061212
将他们解密后得到结果保存为 2.txt,格式如下:21232f297a57a5a743894a0e4a801fc3 admin
7fef6171469e80d32c0559f88b377245 admin888
63a9f0ea7bb98050796b649e85481845 root
eb0a191797624dd3a48fa681d3061212 master
现在我想将1.txt里面的内容替换为2.txt。目前软件市面上的软件无法实现这种效果其一:遇到1,txt里的
21232f297a57a5a743894a0e4a801fc3将他替换为
21232f297a57a5a743894a0e4a801fc3 admin如果没有遇到,就跳过,以此类推------------------------------
想通过mysql实现这一效果,环境:PHPnow-1.5.6,MYsql版本5.0使用软件:Navicat Premium数据库字符串:gb2312 -- GB2312 Simplified Chinese
排序规则:gb2312_chinese_ci字段类型统一为:text,编码utf8
目前个人思路如下:讲纯md5导入md5字段1讲解密后的结果导入pass字段2然后通过语句,将字段1里的内容替换为字段2
解决方案 »
- 新版Mysql安装失败,怎么安装搞这么麻烦了?要啥.netframework...
- mysql C api是否有 在结果中,用字段名key查到value的api?
- mysql declare 变量应用报错,在线等……
- mysqldump 导入两个表数据到同一个sql文件,导出条件如何设置
- 急求,mysql延时插入语句
- POSTGRES数据库如何实现增量备份???
- 我用UPDATE更新某行某列的时候,它也帮我更新了我没指定的该行的某列~~
- 求一句MYSQL的语句~
- 连接不了mysql,怎么回事???
- 如何在linux下配置mysql-jdbc,以及在那里下载?
- 有关mysqldump命令日期方面问题
- VC连不上本机mysql数据库……
2:把2.TXT导入数据库表里,难么?同1
3:两表关联UPDATE难么?不难,
4:UPDATE之后的表1,导出成TXT文件难么?
-> (
->
-> count_2 text
-> );
Query OK, 0 rows affected (0.11 sec)mysql> create table table_b
-> (
->
-> count_2 text
-> );
Query OK, 0 rows affected (0.09 sec)mysql> insert into table_a values('21232f297a57a5a743894a0e4a801fc3'),
-> ('7fef6171469e80d32c0559f88b377245')
-> ,('63a9f0ea7bb98050796b649e85481845'),
-> ('eb0a191797624dd3a48fa681d3061212');
Query OK, 4 rows affected (0.10 sec)
Records: 4 Duplicates: 0 Warnings: 0mysql> insert into table_b values('21232f297a57a5a743894a0e4a801fc3 admin'),
-> ('7fef6171469e80d32c0559f88b377245 admin888')
-> ,('63a9f0ea7bb98050796b649e85481845 root'),
-> ('eb0a191797624dd3a48fa681d3061212 master');
Query OK, 4 rows affected (0.10 sec)
Records: 4 Duplicates: 0 Warnings: 0mysql> select * from table_a;
+----------------------------------+
| count_2 |
+----------------------------------+
| 21232f297a57a5a743894a0e4a801fc3 |
| 7fef6171469e80d32c0559f88b377245 |
| 63a9f0ea7bb98050796b649e85481845 |
| eb0a191797624dd3a48fa681d3061212 |
+----------------------------------+
4 rows in set (0.00 sec)mysql> select * from table_b;
+-------------------------------------------+
| count_2 |
+-------------------------------------------+
| 21232f297a57a5a743894a0e4a801fc3 admin |
| 7fef6171469e80d32c0559f88b377245 admin888 |
| 63a9f0ea7bb98050796b649e85481845 root |
| eb0a191797624dd3a48fa681d3061212 master |
+-------------------------------------------+
4 rows in set (0.00 sec)mysql>
mysql> update table_a a set a.count_2=
->
-> (
-> select b.count_2 a
->
-> from table_b b
-> where substr(b.count_2,1,locate(' ',b.count_2,'1')) =a.count_2
->
-> );
Query OK, 4 rows affected (0.11 sec)
Rows matched: 4 Changed: 4 Warnings: 0mysql> select * from table_a;
+-------------------------------------------+
| count_2 |
+-------------------------------------------+
| 21232f297a57a5a743894a0e4a801fc3 admin |
| 7fef6171469e80d32c0559f88b377245 admin888 |
| 63a9f0ea7bb98050796b649e85481845 root |
| eb0a191797624dd3a48fa681d3061212 master |
+-------------------------------------------+
4 rows in set (0.00 sec)
-> (
->
-> count_2 text
-> );
Query OK, 0 rows affected (0.11 sec)mysql> create table table_b
-> (
->
-> count_2 text
-> );
Query OK, 0 rows affected (0.09 sec)mysql> insert into table_a values('21232f297a57a5a743894a0e4a801fc3'),
-> ('7fef6171469e80d32c0559f88b377245')
-> ,('63a9f0ea7bb98050796b649e85481845'),
-> ('eb0a191797624dd3a48fa681d3061212');
Query OK, 4 rows affected (0.10 sec)
Records: 4 Duplicates: 0 Warnings: 0mysql> insert into table_b values('21232f297a57a5a743894a0e4a801fc3 admin'),
-> ('7fef6171469e80d32c0559f88b377245 admin888')
-> ,('63a9f0ea7bb98050796b649e85481845 root'),
-> ('eb0a191797624dd3a48fa681d3061212 master');
Query OK, 4 rows affected (0.10 sec)
Records: 4 Duplicates: 0 Warnings: 0mysql> select * from table_a;
+----------------------------------+
| count_2 |
+----------------------------------+
| 21232f297a57a5a743894a0e4a801fc3 |
| 7fef6171469e80d32c0559f88b377245 |
| 63a9f0ea7bb98050796b649e85481845 |
| eb0a191797624dd3a48fa681d3061212 |
+----------------------------------+
4 rows in set (0.00 sec)mysql> select * from table_b;
+-------------------------------------------+
| count_2 |
+-------------------------------------------+
| 21232f297a57a5a743894a0e4a801fc3 admin |
| 7fef6171469e80d32c0559f88b377245 admin888 |
| 63a9f0ea7bb98050796b649e85481845 root |
| eb0a191797624dd3a48fa681d3061212 master |
+-------------------------------------------+
4 rows in set (0.00 sec)mysql>
mysql> update table_a a set a.count_2=
->
-> (
-> select b.count_2 a
->
-> from table_b b
-> where substr(b.count_2,1,locate(' ',b.count_2,'1')) =a.count_2
->
-> );
Query OK, 4 rows affected (0.11 sec)
Rows matched: 4 Changed: 4 Warnings: 0mysql> select * from table_a;
+-------------------------------------------+
| count_2 |
+-------------------------------------------+
| 21232f297a57a5a743894a0e4a801fc3 admin |
| 7fef6171469e80d32c0559f88b377245 admin888 |
| 63a9f0ea7bb98050796b649e85481845 root |
| eb0a191797624dd3a48fa681d3061212 master |
+-------------------------------------------+
4 rows in set (0.00 sec)