11/28/2023 0 Comments Create trigger after 100 updatesThey are executed after any SQL operation. They are executed before any SQL operation. Triggers are defined using an SQL statement “CREATE TRIGGER”. Triggers are easy to maintain and they enforce faster application development. The advantage of using triggers is, if any change needs to be done in the application, it is done at the trigger instead of changing each application that is accessing the trigger. They can be accessed and shared among multiple applications. Triggers are stored in the database at once. IntroductionĪ trigger is a set of actions, which are performed for responding to an INSERT, UPDATE or DELETE operation on a specified table in the database. This chapter describes triggers, their types, creation and dropping of the triggers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |