mysql触发器学习记录

mysql触发器表同步
CREATE DATABASE test3 ;
USE test3 ;
CREATE TABLE stu (id INT(20) PRIMARY KEY , stu_name VARCHAR(50) NOT NULL , stu_age DATE NOT NULL) ;
CREATE DATABASE test4 ;
USE test4 ;
CREATE TABLE stu AS SELECT * FROM test3.stu ;
DELIMITER //
CREATE TRIGGER tb
AFTER INSERT ON test3.stu FOR EACH ROW
BEGIN
INSERT INTO test4.stu (id , stu_name , stu_age )VALUES(new.id ,new.stu_name ,new.stu_age) ;

mysql触发器学习记录最先出现在Python成神之路。