MySQL ENCRYPT() function
ENCRYPT() function
MySQL ENCRYPT() encrypts a string using the Unix crypt() system call. The function returns a binary string.
Since the function is based on Unix crypt() system call, on Windows systems, it will return NULL.
Syntax:
ENCRYPT(string, salt)
Arguments
Name | Description |
---|---|
string | A string which is to be encrypted. |
salt | A string with at least two characters. If salt is less than two characters, the function will return NULL. If this argument is not set, the function uses a random value for encryption. |
Syntax Diagram:
MySQL Version: 8.0
Example:
Code:
SELECT ENCRYPT('w3resource', 'encode');
Explanation
The above MySQL statement encrypts w3resource with encoding.
Output:
mysql> SELECT ENCRYPT('w3resource', 'encode'); +---------------------------------+ | ENCRYPT('w3resource', 'encode') | +---------------------------------+ | NULL | +---------------------------------+ 1 row in set (0.00 sec)
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://www.w3resource.com/mysql/encryption-and-compression-functions/encrypt().php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics