Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation	Created
log_my_test_table_queries_insert	ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` TRIGGER log_my_test_table_queries_insert
BEFORE INSERT ON `my_test_table`
FOR EACH ROW
  BEGIN
    DECLARE original_query VARCHAR(1024);
    SET original_query = (SELECT info
                          FROM INFORMATION_SCHEMA.PROCESSLIST
                          WHERE id = CONNECTION_ID());
    INSERT INTO `my_test_table_log` (`query`) VALUES (original_query);
  END	utf8mb4	utf8mb4_unicode_ci	utf8mb4_unicode_ci	2017-08-07 16:59:18.83
Table	Create Table
my_test_table	CREATE TABLE `my_test_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jdoc` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Table	Create Table
my_test_table_log	CREATE TABLE `my_test_table_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `query` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci