MYSQL 加密SQL
INSERT INTO table1 (user, pw) VALUE ('user1', MD5('password1') ) INSERT INTO table1 (user, pw) VALUE ('user1', PASSWORD('password1') ) INSERT INTO table1 (user, pw) VALUE ('user1', SHA1 ('password1') ) 可以通过如下的语句进行密码验证: SELE
INSERT INTO table1 (user, pw) VALUE ('user1', MD5('password1') )
INSERT INTO table1 (user, pw) VALUE ('user1', PASSWORD('password1') )
INSERT INTO table1 (user, pw) VALUE ('user1',
SHA1('password1') )
SELECT * FROM table1 WHERE pw = MD5('password1')
SELECT * FROM test.userpass WHERE pass = SHA1('dddd')
SELECT * FROM test.userpass WHERE pass = password('dddd')
INSERT INTO test.userpass (name,pass,enpass) VALUE ('user3', 'dddd',AES_ENCRYPT('pass','key'));
上面的插入语句有三个字段,“用户名”、“密码”和“加密的密码”。AES_ENCRYPT()函数需要一个“key”来协助加密,同样,解密也需要它
SELECT aes_decrypt(enpass,'key') FROM test.userpass