Server Gigabit Guide

MySQL Trigger and View

You are here:
Estimated reading time: 1 min

MySQL Trigger. 

The MySQL trigger is a database object that is associated with a table. It will be activated when a defined action is executed for the table. The trigger can be executed when you run one of the following MySQL statements on the table: INSERT, UPDATE and DELETE. It can be invoked before or after the event which means it can be schedule to run at certain time.

View.

A view works like a table, but it is not a table. It never exists; it is only a prepared SQL statement that is run when you reference the view name.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MySQL creates a temporary table based on the view definition statement and then executes the incoming query on this temporary table.

First, MySQL combines the incoming query with the query defined the view into one query. Then, MySQL executes the combined query

Both of the properties above can be granted by using the “MySQL Database Wizard” in the cPanel control panel while you can also grant the privilege for the user to a specific database on Website Panel control panel as well by using the “Database manager” option. You may refer below on how to enable the trigger and view on cPanel:

1. Click on the “MySQL” option.MySQL-MySQL Databases

2. Click on the database username shown at the “Privileged Users” column.MySQL-Privileged users-manage Privileges

3. Select the required privilege needed to be given to the database as per below.MySQL-All Privileges

4. Click on the “Make Changes” button to save the privilege assigned.

5. Done!

 

Please refer to the following article to know more. 
Knowledge Base: How to change all MySQL database table collation

Was this article helpful?
Dislike 0
Views: 70