Data Encryption

SQL supports encryption functions to secure sensitive data at rest or in transit.


UPDATE users
SET password = AES_ENCRYPT('mypassword', 'encryption_key')
WHERE user_id = 1;