When using the "Simulate query" feature in phpMyAdmin 5.2.1, certain valid UPDATE statements are reported as affecting 0 rows — even though running the query via "Go" does update the expected rows.
Currently the PhpMyAdmin counts the total rows of a query result every time when LIMIT is not present. If LIMIT is not presented in the user query, default LIMIT (like LIMIT 0, 50) is appended to the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback