https://tech.goyun.info/2020/12/mysql-audit-only-log-successfully.html

MySQL audit: Only Log Successfully Executed Statements for a specific table.json

{
    "filter": {
        "id": "main",
        "class": [
            {
                "name": "table_access_data",
                "event": {
                    "name": [
                        "insert",
                        "update",
                        "delete"
                    ],
                    "log": false,
                    "filter": {
                        "activate": {
                            "and": [
                                {
                                    "field": {
                                        "name": "table_database.str",
                                        "value": "db1"
                                    }
                                },
                                {
                                    "field": {
                                        "name": "table_name.str",
                                        "value": "tb1"
                                    }
                                }
                            ]
                        },
                        "class": {
                            "name": "general",
                            "event": {
                                "name": "status",
                                "log": {
                                    "field": {
                                        "name": "general_error_code",
                                        "value": 0
                                    }
                                },
                                "filter": {
                                    "ref": "main"
                                }
                            }
                        }
                    }
                }
            }
        ]
    }
}