2018
MySQLWARNINGCriticalDMLHIGH confidence
Rows matched / changed / warnings info
Production Risk
None — informational message only.
What this means
This is an informational message returned after an UPDATE statement showing how many rows matched the WHERE clause, how many were actually changed, and how many warnings were generated. It is not an error.
Why it happens
- 1Normal result of any UPDATE statement.
How to reproduce
trigger — this will error
trigger — this will error
UPDATE users SET status = 'active' WHERE id = 1;
expected output
Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0
Sources
Official documentation ↗
MySQL 8.0 — 2018 ER_UPDATE_INFO
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev