Three examples of mysql triggers

Mysql triggers are an important concept of mysql databases. The following describes three examples of mysql triggers for your reference. It is helpful for you to learn about mysql triggers.

 
 

  
  
Example 1
  
  
Delimiter //
  
  
Create trigger InsertUser
  
  
Before insert on user
  
  
For each row
  
  
Begin
  
  
Insert into user_group (uid, gid) values (new. uid, 'group444444444444 ');
  
  
End ;//
  
  
Delimiter;
  
  
 
  
  
Example 2
  
  
Delimiter //
  
  
Create trigger InsertUser
  
  
Before insert on user
  
  
For each row
  
  
Begin
  
  
IF new. Type = 2 then
  
  
Insert into user_group (uid, gid) values (new. uid, 'group444444444444 ');
  
  
Else
  
  
Insert into user_group (uid, gid) values (new. uid, 'group55555555555 ')
  
  
End if;
  
  
End ;//
  
  
Delimiter;
  
  
 
  
  
Example 3:
  
  
Delimiter //
  
  
Create trigger InsertUser
  
  
Before insert on user
  
  
For each row
  
  
Begin
  
  
IF new. type = 1 then
  
  
Insert into user_group (uid, gid) values (new. uid, '578d3369633b47bd9c1fe8bf905cbfb1 ');
  
  
End if;
  
  
IF new. type = 2 then
  
  
Insert into user_group (uid, gid) values (new. uid, '387bcd57fc5a4c3c9de83ee210fef661 ');
  
  
End if;
  
  
End ;//
  
  
Delimiter;
 
 

How to configure connection to multiple mysql servers

Mysql Aggregate functions

MySQL string case-sensitive Conversion Function

Use of MySQL concat Functions

Implementation of MySql remote connection