create trigger tri_users
before insert on users
for each row
begin
insert into users1 (usernmae,password) values ('999','999');
set new.id = 100;
end
mysql是不是不支持begin end语句啊,去掉begin end就能建立触发器了,但是不能一次触发多条语句,网上的人又说mysql也能用begin end的,可是我就是不成功,还是说我用phpMyAdmin的关系,真心不懂,在线求结果!!!
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
|
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 ;
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 ;
mysql> DELIMITER $$
mysql> 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$$
Query OK, 0 rows affected (0.05 sec)
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 ;
不行啊,这个也运行不了
mysql> DELIMITER $$
mysql> 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$$
Query OK, 0 rows affected (0.05 sec)
mysql> DELIMITER ;
mysql>
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 ;
不行啊,这个也运行不了
mysql> DELIMITER $$
mysql> 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$$
Query OK, 0 rows affected (0.05 sec)
//多SQL中导出的触发器语句:DROP TRIGGER IF EXISTS `t_trig`;DELIMITER //CREATE TRIGGER `t_trig` BEFORE INSERT ON `t_goods`FOR EACH ROW beginset NEW.add_date = current_date();INSERT INTO test2 SET a2 = ...
//多SQL中导出的触发器语句: DROP TRIGGER IF EXISTS `t_trig`; DELIMITER // CREATE TRIGGER `t_trig` BEFORE INSERT ON `t_goods` FOR EACH ROW beginset NEW.add_date = current_date();INSERT INTO test2 ...
//多SQL中导出的触发器语句:DROP TRIGGER IF EXISTS `t_trig`;DELIMITER //CREATE TRIGGER `t_trig` BEFORE INSERT ON `t_goods`FOR EACH ROW beginset NEW.add_date = current_date();INSERT INTO test2 SET a2 = ...
//多SQL中导出的触发器语句:DROP TRIGGER IF EXISTS `t_trig`;DELIMITER //CREATE TRIGGER `t_trig` BEFORE INSERT ON `t_goods`FOR EACH ROW beginset NEW.add_date = current_date();INSERT INTO test2 SET a2 = ...
CREATE TRIGGER trigger_activity_id_delete AFTER DELETE ON tp_activity FOR EACH ...BEGIN DELETE FROM tp_code WHERE OLD.id = tp_code.`activity_id`; END 报错: 1 queries executed, 0 success, 1 error...
A 表设置如下触发器 B表插入A表 新增的不重复的数据 begin DECLARE number int; SET number=(select count(1) from tb_program_member where face_match=1 and person_id=new. cardid); ...
在最近在通过navicate连接mysql数据库时,进行查询操作: delimiter $$BEGIN SET @a=1; if (@a > 0) THEN SELECT COUNT(*) from tb_public_effect_tmp;ELSE SELECT * from tb_effect_master;end if; END $$...
CREATE OR REPLACE TRIGGER TR_CGD1BEFORE UPDATE OR INSERT OR DELETE ON BB_MJ_CGD1_TBFOR EACH ROWDECLAREV_COUNT NUMBER;BEGINCASEWHEN UPDATING OR INSERTING THENIF :NEW.DJZT = '结束' THEN:NEW.DJZT := '...
创建触发器:create triggertrigger_name trigger_time trigger_eventon table_namefor each row begin trigger_stmtend注释:触发器只能创建在永久表上,不能创建在临时表上其中trigger_time表示触发时间 ,有...