title: How to get affected row count on WordPress query?
body: <p>This code is to use in WordPress plugin.</p>
  
  <p>The following is my code I am using to insert data from CSV file to database:</p>
  
  <pre><code>$sql="LOAD DATA LOCAL INFILE '".$fileurl."' INTO TABLE ".$table_name."
                  FIELDS TERMINATED BY ','
                  LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`first_name`,`last_name`, `email`, `mobile_phone`, `address_1`, `address_2`, `city`, `state`, `zip`, `about_us` );
                  ";
                  $query = $wpdb-&gt;query($sql);
  </code></pre>
  
  <p>When I do this <code>var_dump($query);</code> it shows <code>int(0)</code>, and data is successfully inserted in table. My question is how can I get number of inserted rows?</p>