What permissions are required to use triggers?

We must have super privileges to create or destroy triggers with the help of CREATE or DROP statements. In addition to this, if the triggered statement uses OLD or NEW, then we also need some additional permissions-

• Use SET NEW.column_name to assign the value of the column = value Then we must have the value of the column UPDATE permissions.
• To use NEW.column_name in an expression to reference the new value of a column, we must have SELECT permission on the column.
• To use NEW.column_name in an expression to reference the new value of a column, we must have SELECT permission on the column. li>

The above is the detailed content of What permissions are required to use triggers?. For more information, please follow other related articles on the PHP Chinese website!