触发器操作 刚学习到触发器,当向一个表table1进行insert操作时进就触发,向table2写入一行同样的数据,该怎么写啊,摸不到头绪 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create trigger tri_name after inert on table1for eache rowinsert into table2(a,b,c) values(new.a,new.b,new.c); 建议参考一下MYSQL官方免费手册中的例子,然后自己尝试写一下。CREATE TABLE test1(a1 INT);CREATE TABLE test2(a2 INT);CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);CREATE TABLE test4( a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b4 INT DEFAULT 0);delimiter |CREATE TRIGGER testref BEFORE INSERT ON test1 FOR EACH ROW BEGIN INSERT INTO test2 SET a2 = NEW.a1; DELETE FROM test3 WHERE a3 = NEW.a1; UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1; END;|delimiter ;INSERT INTO test3 (a3) VALUES (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL);INSERT INTO test4 (a4) VALUES (0), (0), (0), (0), (0), (0), (0), (0), (0), (0); CREATE TRIGGER testref AFTER INSERT ON table1 FOR EACH ROW BEGIN INSERT INTO table2 select * from new; END; create trigger tri_name after inert on t1 for eache row insert into t2(a,b,c) values(new.F1,new.F1,new.F3);将所有字段写上 这个SQL在Mysql为什么通不过?! 明明是正确的,报错,抓狂了 为什么只查出来一条记录? 请教这样的情况SQL语句怎么写 一个java 程序连接不了mysql问题 MYSQL设置问题,送分题,我第一次用! 如何更改数据库的默认编码方式?? 我安了mysql,请问如何使用mysql? 请问各位,我在安装 mysql 遇到的麻烦 求助——mysql enum数据类型 mysql建立触发器问题 为什么数据类型不正确,MYSQL也不会提示?
for eache row
insert into table2(a,b,c) values(new.a,new.b,new.c);
CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
b4 INT DEFAULT 0
);delimiter |CREATE TRIGGER testref BEFORE INSERT ON test1
FOR EACH ROW BEGIN
INSERT INTO test2 SET a2 = NEW.a1;
DELETE FROM test3 WHERE a3 = NEW.a1;
UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
END;
|delimiter ;INSERT INTO test3 (a3) VALUES
(NULL), (NULL), (NULL), (NULL), (NULL),
(NULL), (NULL), (NULL), (NULL), (NULL);INSERT INTO test4 (a4) VALUES
(0), (0), (0), (0), (0), (0), (0), (0), (0), (0);
FOR EACH ROW BEGIN
INSERT INTO table2 select * from new;
END;
for eache row
insert into t2(a,b,c) values(new.F1,new.F1,new.F3);
将所有字段写上