mysql - how to get value from select query in trigger in mysql5? -

how value select query in trigger , insert value in table?

for insert trigger query use object new
update trigger query use object old , new
delete trigger query use object old

example 1 : if ran insert mytable (num) values (10);
in insert trigger, reference column new.num (10);

example 2 : if ran update mytable set num = 41 num = 10;
in update trigger, reference old.num (10) , new.num (41)

example 3 : if ran delete mytable num = 104;
in delete trigger, reference old.num (104)

use this:

delimiter $$  create trigger my_trigger after update on my_update_table each row begin      declare p1,p2 varchar(50);      select pricename p1 priceies priceid=old.priceid;     select pricename p2 priceies priceid=new.priceid;     insert auditlog(oldvalue, newvalue) values (p1,p2);  end $$  delimiter ;