新建表c1CREATE TABLE c1 (id int(11) NOT NULL auto_increment PRIMARY KEY,kl VARCHAR(255))
向表c1插入数据INSERT INTO c1(kl) VALUES('李'),('周'),('王'),('赵')
新建表c2CREATE TABLE c2 (id int(11) NOT NULL auto_increment PRIMARY KEY,kl VARCHAR(255))
向表c2插入数据INSERT INTO c2(kl) VALUES('1'),('1'),('1'),('1')
创建触发器c1表新增值,同样新增c2表的值create trigger c1_insert_c2 after INSERT
on c1 for each ROW
BEGIN
insert into c2(kl) VALUES(new.kl);
END
向表c1新增值,并查询c1的值与c2的值insert into c1 (kl) VALUES('韩')
select * from c1;
select * from c2;