我们可以在带有用户密码列的MySQL表中将MD5转换为SHA256吗?
使用SHA2()将MD5密码转换为SHA256。它计算SHA-2系列哈希函数,即SHA-224,SHA-256,SHA-384和SHA-512。
让我们首先创建一个表-
mysql> create table DemoTable818(UserPassword text);
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable818 values(MD5('John_123')); mysql> insert into DemoTable818 values(MD5('999Carol@22'));
使用select语句显示表中的所有记录-
mysql> select *from DemoTable818;
这将产生以下输出-
+----------------------------------+ | UserPassword | +----------------------------------+ | 47c7d0987db4e59e2264ce9fefce4977 | | 950aa70edd5b686a807b3bfffdf2248c | +----------------------------------+ 2 rows in set (0.00 sec)
以下是将MD5转换为SHA256的查询-
mysql> update DemoTable818 set UserPassword=SHA2(UserPassword,256); Rows matched: 2 Changed: 2 Warnings: 0
让我们再次检查表记录-
mysql> select *from DemoTable818;
这将产生以下输出-
+------------------------------------------------------------------+ | UserPassword | +------------------------------------------------------------------+ | 8b68c46294a9ccb2449324c24fe774f95b7c14e4b56fc51c7f8e6c5b01c7020f | | 9cc80741546051ae3de7d31246327968c98af3c65125376acb7b49a0760d42a3 | +------------------------------------------------------------------+ 2 rows in set (0.00 sec)