Binlog Formats: Statement, Row & Mixed
Learn Binlog Formats: Statement, Row & Mixed (Binary Logs, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction binlog_format chooses what is logged. STATEMENT logs the SQL text, ROW logs the before/after image of each changed row, MIXED uses statement unless it is unsafe, then switches to row. ROW is the default since MySQL 5.7.7.