Tag

STATEMENT

1 views collected around this technical thread.

Top Architect
Top Architect
Jun 29, 2024 · Databases

MySQL Update Behavior with Identical Data under ROW and STATEMENT Binlog Formats

This article investigates whether MySQL re‑executes an UPDATE statement that sets a column to its current value, comparing behavior under binlog_format=ROW and binlog_format=STATEMENT with binlog_row_image=FULL, and presents test steps, results, and conclusions.

DatabaseInnoDBROW
0 likes · 12 min read
MySQL Update Behavior with Identical Data under ROW and STATEMENT Binlog Formats
FunTester
FunTester
Dec 12, 2023 · Backend Development

Understanding ResultSet Resource Release and Statement Concurrency in MySQL JDBC

This article examines how MySQL's JDBC driver manages ResultSet resource release, the internal close mechanisms, and the concurrency limitations of Statement objects, illustrated with code excerpts and a Groovy virtual‑thread demo that reveals runtime exceptions when ResultSets are accessed after implicit closure.

JDBCResultSetSTATEMENT
0 likes · 8 min read
Understanding ResultSet Resource Release and Statement Concurrency in MySQL JDBC