title: rows object returned after executing stored procedure in node-mysql
body: <p>I've a subquery executing and was looking for insertId's but I'm getting a rows object with no information.</p>
  
  <p><strong>My stored procedure</strong></p>
  
  <pre><code>CREATE PROCEDURE `day`(IN start DATE, IN end DATE, IN event_id INT)
  BEGIN
      WHILE start &lt;= end DO
          INSERT INTO day(date, event_id) VALUES(start, event_id);
          SET start = start + 1;
      END WHILE;
  END
  </code></pre>
  
  <p><strong>Node.js</strong></p>
  
  <pre><code>var query = "SET @start = '" + request.body.from  + "'; \
      SET @end = '" + request.body.to + "'; \
      SET @event_id = " + rows.insertId + "; \
      CALL day(@start, @end, @event_id);";
  
  connection.query(query, [], function(error, rows, fields) {
      console.log(rows);
  }
  </code></pre>
  
  <p><strong>Console output for the <code>rows</code></strong></p>
  
  <pre><code>[
      {
        "fieldCount": 0,
        "affectedRows": 0,
        "insertId": 0,
        "serverStatus": 11,
        "warningCount": 0,
        "message": "",
        "protocol41": true,
        "changedRows": 0
      },
      {
        "fieldCount": 0,
        "affectedRows": 0,
        "insertId": 0,
        "serverStatus": 11,
        "warningCount": 0,
        "message": "",
        "protocol41": true,
        "changedRows": 0
      },
      {
        "fieldCount": 0,
        "affectedRows": 0,
        "insertId": 0,
        "serverStatus": 11,
        "warningCount": 0,
        "message": "",
        "protocol41": true,
        "changedRows": 0
      },
      {
        "fieldCount": 0,
        "affectedRows": 1,
        "insertId": 0,
        "serverStatus": 3,
        "warningCount": 0,
        "message": "",
        "protocol41": true,
        "changedRows": 0
      }
    ]
  </code></pre>
  
  <p><strong>Expectations and Question</strong></p>
  
  <p>I need some kind of actual information as a result of the insertions by stored procedure. </p>