java - What is use of trigger , Can anyone explain with an example that where we should use? -

i beginner in sql, please explain example. know how create simple trigger, don't have real example should use.

a trigger used automatically act (i.e., apply logic) when action performed. simple example if have column holding last modification date - on every insert on update table, you'd want column updated current timestamp, regardless of how done, or application.