MySQL Trigger sample snippet

confirm_trigger.sql

/* for insert */
insert into articles (title) values ('insert_test');
select * from articles;
select * from trigger_sample;

/* for udpate */
update articles set title = 'update_test' where id = 1;
select * from articles;
select * from trigger_sample;

/* for delete */
delete from articles where id = 1;
select * from articles;
select * from trigger_sample;

creaate_table.sql

drop database if exists trigger_sample_db;
create database trigger_sample_db;
use trigger_sample_db;
create table articles (
  id int auto_increment primary key,
  title varchar(255)
);
create table trigger_sample (
  id int auto_increment primary key,
  query varchar(10),
  article_title varchar(255),
  created_at datetime
);

/* confirm create tables */
show columns from articles;
show columns from trigger_sample;

create_trigger.sql

/* for insert */
create \
  trigger insert_trigger \
  after insert \
  on articles for each row \
  insert into trigger_sample (query, article_title, created_at) \
  values ('Insert', new.title, now());

/* for update */
create \
  trigger update_trigger \
  after update \
  on articles for each row \
  insert into trigger_sample (query, article_title, created_at) \
  values ('Update', new.title, now());

/* for delete */
create \
  trigger delete_trigger \
  after delete \
  on articles for each row \
  insert into trigger_sample (query, article_title, created_at) \
  values ('Delete', old.title, now());

show triggers\G