DES_DECRYPT()

EXAMPLES

CREATE TABLE t1 (a CHAR(240), b BIT(48));
INSERT INTO t1 VALUES
  ('a',b'0001'), ('b',b'0010'), ('c',b'0011'), ('d',b'0100'),
  ('e',b'0001'), ('f',b'0101'), ('g',b'0110'), ('h',b'0111'),
  ('i',b'1000'), ('j',b'1001');
SELECT DES_DECRYPT(a, 'x'), HEX(b) FROM t1;
+---------------------+--------+
| DES_DECRYPT(a, 'x') | HEX(b) |
+---------------------+--------+
| a                   | 1      |
| b                   | 2      |
| c                   | 3      |
| d                   | 4      |
| e                   | 1      |
| f                   | 5      |
| g                   | 6      |
| h                   | 7      |
| i                   | 8      |
| j                   | 9      |
+---------------------+--------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES