21,893
社区成员




DROP TABLE IF EXISTS `d`;
CREATE TABLE `d_copy` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`t1` char(20) NOT NULL,
`t2` tinyblob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into d(t1,t2) values('test',AES_ENCRYPT('500240190000001616','jam'));
select *,AES_DECRYPT(t2,'jam') card from d where t1='test'
select * from d where t2=AES_ENCRYPT('500240190000001616','jam')