A. num_rows()
B. affected_rows()
C. changed_rows()
D. new_rows()
The method num_rows() is only useful for determining the number of rows retrieved by a SELECT query. But to retrieve the number of rows affected by INSERT, UPDATE, or DELETE query, use affected_rows().