MySQL `BEFORE INSERT TRIGGER` how can I skip data insertion under condition?

Question

Possible Duplicate:
MySQL Trigger to prevent INSERT under certain conditions

In MySQL BEFORE INSERT TRIGGER how can I skip data insertion under condition?

delimiter //
drop trigger if exists test_trigger //
create trigger test_trigger before insert on t
for each row
begin
  set @found := false;

  #Some code

  if @found then
    #How to skip the data insertion under condition?
  end if;
end   //

delimiter ;

Devart · Accepted Answer · 2012-11-22T12:01:44.413

5

Two solutions, both raise an error:

Call non-existent stored procedure - CALL non_existent_proc()
Use SIGNAL statement to raise the error (MySQL 5.5).

Example 1:

...
IF @found THEN
  CALL non_existent_proc();
END IF;
...

Example 2:

...
IF @found THEN
  SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = 'Wrong data';`
END IF;
...

edited Nov 22 '12 at 12:01

answered Nov 22 '12 at 11:00

Devart

119,203
23
166
186

Is there any way to do this silently? – eisberg Nov 22 '12 at 12:23
Use procedure with parameters instead of trigger, and add records after condition. – Devart Nov 22 '12 at 12:52
So there is no way via triggers? – eisberg Nov 22 '12 at 12:53
1

Unfortunately, there is no way. – Devart Nov 22 '12 at 13:11
This is very disappointing. But still: Thank you :-) – eisberg Nov 22 '12 at 13:12

MySQL `BEFORE INSERT TRIGGER` how can I skip data insertion under condition?

1 Answers1

Linked