Question discussion

Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

289544Medium 1 reply 855 views
16
Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?
  • Anum_rows()
  • Baffected_rows()
  • Cchanged_rows()
  • Dnew_rows()
Correct answer: B

Discussion 1

0
CCommunity
affected_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().