Question

How can we get the number of rows affected by query?

Answer 1

Number of rows can be obtained by

SELECT COUNT (user_id) FROM users;