Simple use of table triggers in MySQL

I've been exposed to triggers before, but I haven't written them myself, so here's a simple example:

The function is: two tables t_test,t_emp; Adding a trigger to T_test lets t_test add 1 to the NUM field value in T_emp each insertion of a single piece of data;

1, Build T_test table

2. Another table t_emp as follows:

3. Right-click the design table, T_test, and then the following:

The 4.t_emp initialization value is 0, as follows:

5.t_test Add a record:

6. Open the T_emp table and find that num value automatically becomes 1! As follows:

Of course, can also be changed to other functions of the trigger, here is not explained, friends if you are interested in more to try.

Simple use of table triggers in MySQL