Friday, 16 November 2018  
 
Dolvin Blog
Dolvin Blog » Our DB
Triggers In MySql
by. Dolvin ≈ July 16, 2007
Today I learned bout Triggers in MySql,
Triggers are programmable events that react to queries and reside directly on the database server. Triggers can be executed before or after INSERT, UPDATE or DELETE statements.

with triggers, we can know what data has been insert, update or delete.
actually it's easy to create, this is the example:

DELIMITER |

CREATE TRIGGER newsCounter AFTER INSERT ON News
  FOR EACH ROW BEGIN
      INSERT INTO NewsCount (newsItemCount) (SELECT count(*) FROM News);
  END;

|
DELIMITER ;


that example, is to get and insert the news count at NewsCount table when user insert at News table


and to get a triggers list at your database, you can run this:
SHOW TRIGGERS;


but u cannot create triggers from phpMyAdmin, it just can create from MySql Client like SQLyog (http://www.webyog.com/en/)

and sometimes you have to be a super user to create triggers at your database.

for more information bout triggers, u can visit this site:
http://dev.mysql.com/doc/mysql/en/triggers.html

it's quite fun, when u have to learn something new.. at your office
 
<< back to Dolvin's Blog




:: Your Comment of Triggers In MySql ::

July 18, 2007

August 22, 2007
Page : 1 

:: November '18 ::
 
 
S
M
T
W
T
F
S
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
   

:: My Blog List ::
 
   
   

:: Blog Category ::
 
 
» Books
» Christian Soul
» Fashion
» Film
» Foods & Drinks
» Games
» General Info
» Health
» Jokes
» Love
» Music
» My Life
» Programming
» Technology
 
   

:: Site Links ::
 
 
» Angel Sulistyo
» Anton Ongsono
» Darwin
» Fellys
» Inge
» Kado Imut
» Koleksi Unik
» Lie Fung
» Lintaka
» Lobak
» Rosrita
 
   
 
:: Dolvin Website | Dolvin Blog | Our DB ::
Copyright © Lavinia - 2006 - 2018