ENCRYPT(str[,salt]) encrypts str using the Unix crypt() system call. : ENCRYPT « Encryption Compression Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Encryption Compression Functions
  3. ENCRYPT

Returns a binary string.

The salt argument should be at least a two-character string.

If no salt argument is given, a random value is used.

mysql>
mysql> SELECT ENCRYPT('hello');
+------------------+
| ENCRYPT('hello') |
+------------------+
| NULL             |
+------------------+
1 row in set (0.01 sec)

mysql>








19.10.ENCRYPT
19.10.1.ENCRYPT(str[,salt]) encrypts str using the Unix crypt() system call.
19.10.2.Use ENCRYPT function to ENCRYPT first name