MySQL Triggers Tutorials for Beginners #1 - Introduction - What, Why & Limitations of using Triggers

In this video we'll see:

Introduction -
What are triggers ?
Why triggers ?
Limitations of using mysql triggers ?

Database Triggers
======================
1. Database triggers are the database objects which reside in system catalog.
The triggers are special type of procedures which can be called implicitly.

2. Each Trigger is associated with a table can be activated on any DML statement like
(Insert, Update or Delete)


3. A SQL trigger is a special type of stored procedure. It is special because it is not
called directly like a stored procedure. The main difference between a trigger and a
stored procedure is that a trigger is called automatically when a data modification
event is made against a table whereas a stored procedure must be called explicitly.

Why Triggers
=====================

1. Triggers help us to enforce business rules.

2. Triggers help us to validate data even before they are inserted or updated.

3. Triggers help us to keep log of records like maintaining audit trail.

4. SQL triggers provide an alternative way to check the integrity of data.

Limitations of using Triggers
=========================
1. SQL triggers are invoked and executed invisible from the client applications,
therefore, it is difficult to figure out what happens in the database layer.

2. SQL triggers may increase the overhead of the database server.

SOCIAL :
===============

Other Tutorials
===============
Wordpress Customizations:
---------------------------------
and many more...

Javascript framework:
----------------------------------

PHP Frameworks:
----------------------------------

Tags
----------------------------------
mysql triggers tutorials,
mysql triggers for beginners tutorial,
step by step mysql trigger tutorial,
beginners tutorial for mysql triggers,
php mysql triggers tutorials,
online web tutor,
online web tutor mysql triggers tutorial,
online web tutor sanjay,
basics of mysql triggers,
complete mysql triggers tutorial,
tutorials for mysql triggers for beginners,

Thanks
Online Web Tutor
Keep learning and Sharing :)

[RakeshKumar-yvys]

hi sir, How i rearrange column value in sequence without primary key (column have number type), with multiple condition ig, col1=somevalue, col2=somevalue, col3=somevalue after delete.

[fooballers]

annoying sound...talk to grown up... not 5 yr olds