mysql中异常的dml怎么查看

sudo tail -f /var/log/mysql/error.log

mysql> INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> SHOW WARNINGS;
+-------+------+------------------------------------------------+
| Level | Code | Message                                        |
+-------+------+------------------------------------------------+
| Note  | 1265 | Data truncated for column 'column2' at row 1 |
+-------+------+------------------------------------------------+

mysql> SELECT * FROM table_name WHERE column1 = 'value1';
+----+--------+--------+
| id | column1 | column2 |
+----+--------+--------+
|  1 | value1 | value2 |
+----+--------+--------+

mysql> EXPLAIN SELECT * FROM table_name WHERE column1 = 'value1';
+----+-------------+-----------+------------+------+---------------+------+---------+------+------+----------+-------------+
| id | select_type | table     | partitions | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra       |
+----+-------------+-----------+------------+------+---------------+------+---------+------+------+----------+-------------+
|  1 | SIMPLE      | table_name | NULL       | ALL  | NULL          | NULL | NULL    | NULL |    1 |   100.00 | Using where |
+----+-------------+-----------+------------+------+---------------+------+---------+------+------+----------+-------------+

DELIMITER $$
CREATE TRIGGER after_insert_trigger
AFTER INSERT ON table_name
FOR EACH ROW
BEGIN
    IF NEW.column2 IS NULL THEN
        INSERT INTO error_log (table_name, column_name, error_message)
        VALUES ('table_name', 'column2', 'Column2 cannot be null');
    END IF;
END$$
DELIMITER ;

mysql> INSTALL PLUGIN audit_log SONAME 'audit_log.so';
mysql> SET GLOBAL audit_log_policy = ALL;