在user_info 表中对存储口令的列进行加密

CREATE TABLE user_info (
emp_id INTEGER NOT NULL PRIMARY KEY,
user_name CHAR(80),
user_pwd CHAR(80) )

CREATE TRIGGER encrypt_new_user_pwd
 BEFORE INSERT
 ON user_info
 REFERENCING NEW AS new_pwd
 FOR EACH ROW
 BEGIN
 SET 
new_pwd.user_pwd=ENCRYPT(new_pwd.user_pwd,
'8U3dkA');
 END

CREATE TRIGGER encrypt_updated_pwd
 BEFORE UPDATE OF user_pwd
 ON user_info
 REFERENCING NEW AS new_pwd
 FOR EACH ROW
 BEGIN
     SET 
new_pwd.user_pwd=ENCRYPT(new_pwd.user_pwd,
'8U3dkA');
 END

INSERT INTO user_info
VALUES ( '1', 'd_williamson', 'abc123')