SET block_encryption_mode = 'aes-256-cbc';SET @KEY = 'JGe7aPAMNiS1x6BI';

SET @iv = 'Z84HIR7znTEMLkOI';

SELECT

TO_BASE64 (

AES_ENCRYPT( '13669091204', @KEY, @iv )) AS phone;

SELECT CONVERT

( AES_DECRYPT( FROM_BASE64 ( 'dkicrOxIgGNcxW3leghbzw==' ), @KEY, @iv ) USING UTF8 ) AS phone;

SET block_encryption_mode = 'aes-256-ecb'; select TO_BASE64(AES_ENCRYPT('13669091204','EMc5GPSDUNujzHNSzVcvSLZXdubZ3kHK')) as phone ; SET block_encryption_mode = 'aes-256-ecb'; select Convert(AES_DECRYPT( FROM_BASE64('dR1d77KGVNI+Omfc9Lbjzw=='),'EMc5GPSDUNujzHNSzVcvSLZXdubZ3kHK') USING UTF8) as phone;