MySQL - history table + trigger 만들기

+ mariadb

 

 

[1] mysql tutorial : https://www.mysqltutorial.org/mysql-create-table/

[2] MYSQL DOCUMENTATION
  - 5.7 https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html

  - 8.0 https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html

[3] StackoverFlow : https://stackoverflow.com/questions/6787794/how-to-log-all-changes-in-a-mysql-table-to-a-second-one

[4] blog : https://kahimyang.com/kauswagan/code-blogs/552/create-history-record-for-every-change-in-mysql-table-audit-trail-mysql-trigger