Is there an SQL Server SET NOCOUNT equivalent in MySQL?

Question

Does MySQL have an equivalent SQL statement SET NOCOUNT ON?

Answer 1

SET NOCOUNT ON stops the message indicating the number of rows affected by the Transact-SQL statement from returning as part of the results .

MySQL does not report the number of rows affected by the query, so there is no such function.

If you want, you can find out about the number of rows affected by the ROW_COUNT () function immediately after the request:

DELETE FROM mytable WHERE name="John";
SELECT ROW_COUNT();

Answer 2

As far as I know, there is no analogue.