Can a trigger for a table can be applied for tracking in same table?

Posted by Parth on Stack Overflow See other posts from Stack Overflow or by Parth
Published on 2010-04-07T12:09:50Z Indexed on 2010/04/07 12:13 UTC
Read the original article Hit count: 159

Filed under:
|
|

Can a trigger for a table can be applied for tracking in same table?

That is IF I have table Say "employee" Now can i create a triggers such that it tracks the change in the same "employee" table

trigger such as

create trigger "<triggers_name>"  before insert on employee
For each row
Begin
 insert into employee field = timestamp;
end

© Stack Overflow or respective owner

Related posts about mysql

Related posts about triggers