aes_encrypt insert into table

Question

my query is not work

INSERT INTO rebuilder (id_utente, pwd)VALUES('75693',AES_ENCRYPT('password','set'))

I haven't errors but the pwd value in DB table is NULL.

Ideas? Tnx Stefania

Answer 1

see SQLFIDDLE

create table rebuilder (
  id_utente int,
  pwd varbinary(200) 
);

-- data
insert into rebuilder (id_utente, pwd) 
values (75693,aes_encrypt('password','set'));

---

see SQLFIDDLE