开发者社区> 问答> 正文

What are MySQL Triggers?

已解决

What are MySQL Triggers?

展开
收起
1780169608831412 2021-10-16 16:49:19 434 0
2 条回答
写回答
取消 提交回答
  • 网络规划设计师、敏捷专家、CISP、ITSS服务经理、ACA全科目、ACP4项、ACE、CBP、CDSP、CZTP等。拥有 PRINCE2 Foundation/Practitioner、CCSK、ITIL、ISO27001、PMP等多项国际认证。 专利5+、期刊10+、知识产权师。核心期刊审稿人。
    采纳回答

    A trigger is a task that executes in response to some predefined database event, such as after a new row is added to a particular table. Specifically, this event involves inserting, modifying, or deleting table data, and the task can occur either prior to or immediately following any such event. Triggers have many purposes, including:

    Audit Trails
    Validation
    Referential integrity enforcement
    
    2021-10-16 17:27:30
    赞同 1 展开评论 打赏
  • Introduction to MySQL trigger: 1. Trigger is a method that MySQL provides to programmers and data analysts to ensure data integrity. It is a special stored procedure related to watch events. 2. You can force the data to be checked or converted before writing to the data table.

    2021-10-16 17:20:44
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
One Box: 解读事务与分析一体化数据库 HybridDB for MySQL 立即下载
One Box:解读事务与分析一体化数据库HybridDB for MySQL 立即下载
如何支撑HTAP场景-HybridDB for MySQL系统架构和技术演进 立即下载

相关镜像