mysql触发器的例子，代码如下：
mysql> CREATE TABLE Employee( //创建表
-> id int,
-> first_name VARCHAR(15),
-> last_name VARCHAR(15),
-> start_date DATE,
-> end_date DATE,
-> salary FLOAT(8,2),
-> city VARCHAR(10),
-> description VARCHAR(15)
-> );
Query OK, 0 rows affected (0.02 sec)
mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)
-> values (1,'Jason', 'Martin', '19960725', '20060725', 1234.56, 'Toronto', 'Programmer');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)
-> values(2,'Alison', 'Mathews', '19760321', '19860221', 6661.78
最后
以上就是高贵芒果最近收集整理的关于mysql触发器更新自己表_mysql触发器实例：更新表数据之前触发的全部内容，更多相关mysql触发器更新自己表_mysql触发器实例内容请搜索靠谱客的其他文章。
发表评论 取消回复