/ Published in: MySQL
Expand |
Embed | Plain Text
## Adding and testing AES encrypted password field DROP TABLE IF EXISTS `testGKAES`; CREATE TABLE `testGKAES`( `uid` INT(15) NOT NULL AUTO_INCREMENT, `ufname` VARCHAR(15), `upassword` BLOB, PRIMARY KEY(`uid`) ); INSERT INTO testGKAES VALUES('1','user', AES_ENCRYPT('password', 'key') ); INSERT INTO testGKAES VALUES('2','mere', AES_ENCRYPT('balloon', 'key') ); INSERT INTO testGKAES VALUES('3','kurtasg', AES_ENCRYPT('zebra', 'key') ); SELECT * FROM testGKAES WHERE ufname='user' AND upassword=AES_ENCRYPT('password','key'); SELECT * FROM testGKAES WHERE ufname='mere' AND upassword=AES_ENCRYPT('balloon','key'); SELECT * FROM testGKAES WHERE ufname='kurtasg' AND upassword=AES_ENCRYPT('zebra','key'); SELECT AES_DECRYPT(upassword,'key') FROM testGKAES;
You need to login to post a comment.
