加密函数

MD5()

信息摘要算法

  1. mysql> SELECT MD5(123);
  2. +----------------------------------+
  3. | MD5(123)                         |
  4. +----------------------------------+
  5. | 202cb962ac59075b964b07152d234b70 |
  6. +----------------------------------+
  8. -- 加密插入数据
  9. mysql> INSERT INTO user (name,age,sex) VALUES(MD5('加密'),MD5(21),MD5('人妖'));
  10. Query OK, 1 row affected (0.09 sec)

SHA()

  1. mysql> SELECT SHA(123);
  2. +------------------------------------------+
  3. | SHA(123)                                 |
  4. +------------------------------------------+
  5. | 40bd001563085fc35165329ea1ff5c5ecbdbbeef |
  6. +------------------------------------------+