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....
User Profile
Collapse
-
trigger for creating a csv file
-
java declaration not clear
I got a declaration like this.
Object obj=constructor .newInstance(ne w Object[] {"abc"});
//constructor is a object of Constructor class(using reflection)
i am not clear with the declarartion like this.can some1 explain what is in the brace{"abc"}, as well as the complete declaration in detail.
thanx in advance.
No activity results to display
Show More