Java Backend Technology

May 3, 2022 · Databases

Why MySQL UPDATE Affected Rows Can Mislead Your Business Logic

In MySQL, an UPDATE that modifies no actual data returns an affected‑rows count of zero, making it unreliable for business logic that distinguishes between unchanged rows and non‑existent records, so developers should avoid using this count for critical decisions.