Skip to content

Instantly share code, notes, and snippets.

@xakrume
Last active December 22, 2015 19:58
Show Gist options
  • Save xakrume/6522759 to your computer and use it in GitHub Desktop.
Save xakrume/6522759 to your computer and use it in GitHub Desktop.
mysql> use nersh;
mysql> SHOW TRIGGERS\G
*************************** 1. row ***************************
Trigger: update_order_issue
Event: UPDATE
Table: order_issue
Statement: INSERT INTO `templog` (act, tbl, pkey, comment) VALUES ('update', 'order_issue', NEW.id, CONCAT('set user_id = ', NEW.user_id))
Timing: AFTER
Created: NULL
sql_mode:
Definer: nersh@%
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: latin1_swedish_ci
*************************** 2. row ***************************
Trigger: update_order_issue_archive
Event: UPDATE
Table: order_issue_archive
Statement: INSERT INTO `templog` (act, tbl, pkey, comment) VALUES ('update', 'order_issue_archive', NEW.id, CONCAT('set user_id = ', NEW.user_id))
Timing: AFTER
Created: NULL
sql_mode:
Definer: nersh@%
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: latin1_swedish_ci
*************************** 3. row ***************************
Trigger: update_user_addressbook
Event: UPDATE
Table: user_addressbook
Statement: INSERT INTO `templog` (act, tbl, pkey, comment) VALUES ('update', 'user_addressbook', NEW.id, CONCAT('set user_id = ', NEW.user_id))
Timing: AFTER
Created: NULL
sql_mode:
Definer: nersh@%
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: latin1_swedish_ci
*************************** 4. row ***************************
Trigger: delete_user_addressbook
Event: DELETE
Table: user_addressbook
Statement: INSERT INTO `templog` (act, tbl, pkey, comment) VALUES ('delete', 'user_addressbook', OLD.id, CONCAT('delete from user_addressbook where user_id = ', OLD.user_id))
Timing: AFTER
Created: NULL
sql_mode:
Definer: nersh@%
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: latin1_swedish_ci
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment