FilesExpand file tree

 master

/

testingtrigger_mysql.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

23 lines (16 loc) · 404 Bytes

 master

/

testingtrigger_mysql.sql

Copy path

Top

File metadata and controls

• Code
• Blame

23 lines (16 loc) · 404 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

drop database if exists testingtrigger;

create database testingtrigger;

use testingtrigger;

create table test (

id int primary key,

name varchar(255),

tobedeleted varchar(1) default 'N'

);

delimiter $$

create trigger test_trigger before insert on test for each row

begin

delete from test where tobedeleted = 'Y';

end;$$

delimiter ;

insert into test values (1,'blabla','N');

select * from test;