trigger for creating a csv file

[nilotpal sarkar]

i am new in triggers.
i want a trigger that would fire when i insert rows in table and would create a csv file of the datas in the table.
is it possible in mysql?
i wrote:


create trigger trg_af_ins_test 1 after insert on test1
begin
select * into outfile 'trigfile.csv'
fields terminated by '\t'
lines terminated by '\n'
from emp;
end;

please help.
thanx in advance.

[Luuk]

change the line "FROM EMP;" to "FROM test1"...