Count and print the number of rows updated at the end of the updateQuery method in the format – “5 row(s) updated.”

Description

Part #1: Complete implementation of updateQuery method:

1. Count and print the number of rows updated at the end of the updateQuery method in the format – “5 row(s) updated.”.

2. Implement feature to handle where clause (i.e., the whereColIdx parameter is not -1) with 3 different conditions (‘=’, ‘<>’, and ‘like’) in a query, as in “update test.csv set raters=3 where title like ‘The’;”. See SQLAirBase::matches helper method. For this feature you only print rows with column-values (i.e., value in column indicated by whereColIdx) that match the given condition. See SQLAirBase::matches helper method. Note that given a row, you can get value via row.at(whereColIdx).

3. Of course, you can use the selectQuery method to help guide your implementation.

 

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)