一、导入表结构

USE `qskj_03`;

/*Table structure for table `test` */

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (

    `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',

    `username` varchar(200) NOT NULL COMMENT '用户名',

    `mobile` varchar(100) NOT NULL COMMENT '电话号码',

    `enmobile` varbinary(100) NOT NULL COMMENT '加密后的电话号码',

    KEY `id` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

二、插入一条数据

INSERT INTO test(username,mobile,enmobile)VALUES

('曹操','17779740665',AES_ENCRYPT('17779740665','key'));

三、对加密数据进行解密

SELECT t1.*,AES_DECRYPT(t1.`enmobile`,'key') AS '解密后的电话号码'

FROM test t1;