mysql> create table xxx (id int auto_increment primary key, data text);

Query OK, 0 rows affected (0.07 sec)



mysql> create trigger enc_xxx before insert on xxx for each row set NEW.data = encode(NEW.data, 'parola');

Query OK, 0 rows affected (0.10 sec)



mysql> insert into xxx (data) values ('hello world');

Query OK, 1 row affected (0.03 sec)



mysql> select * from xxx;

+----+-------------+

| id | data        |

+----+-------------+

|  1 | ЦС~hIЗїр    |

+----+-------------+

1 row in set (0.02 sec)



mysql> select *, decode(data, 'parola') from xxx;

+----+-------------+------------------------+

| id | data        | decode(data, 'parola') |

+----+-------------+------------------------+

|  1 | ЦС~hIЗїр    | hello world            |

+----+-------------+------------------------+

1 row in set (0.00 sec)

Редактирано от Dakota на 07.04.06 19:42.