Search results for " create SQL trigger"

Create SQL Trigger

General A trigger is a stored procedure that automatically executes when an event occurs in the database server.Triggers execute when users try to modify something or behind an event that generate changes on the data base.There are three kind of triggers: for insert , update , and delete.The most important events correspond to Transact-SQL CREATE, ...

MySQL Stored procedures

Do you want to know "what's new" in version 5 of MySQL? There are new features added to this version like stored procedures, triggers, views, information_schema. For those who use MySQL for databases administration this is a very good news. For a better understanding of the stored procedures importance I will give a definition and an example. A stored ...