How do you get the number of rows affected by query in SQL mysql?

Question

Hello
How do you get the number of rows affected by query?
please reply me. i am waiting for your reply.
Thanx

Answer 1

SELECT COUNT (user_id) FROM users would only return the number of user_id’s.
Thanx