Database system Information function encryption function

Version ()

Returns the version number of the database

CONNECTION_ID ()

Returns the number of connections to the server

Database (), schema

Returns the current database name

User (), System_user ()

Returns the current user

Cryptographic functions

Password (str)

The function can encrypt the string str, in general, password (str) is used to encrypt the user's password

MD5

The MD5 (str) function hashes the string str and can be used for some common data encryption that does not require decryption

Encode (STR,PSWD_STR) and decode (CRYPT_STR,PSWD_STR)

The Encode function can use the encrypted password Pswd_str to encrypt the string str, and the result of the encryption is a binary number that needs to be saved with a BLOB type of field. This function is a pair with decode and requires the same password to decrypt

Database system Information function encryption function