title: How to insert bulk record
body: <p>I am working on API development using AWS API getaway and lambda.
  I am using Serverless MySQL <a href="https://www.npmjs.com/package/serverless-mysql" rel="nofollow noreferrer">https://www.npmjs.com/package/serverless-mysql</a> package for mysql connection and operation.</p>
  
  <p>but I am unable to insert multiple records. If I pass the array of records to insert function it only insert single records. </p>
  
  <p>Please suggest me how would I insert multiple records without using loop. </p>
  
  <pre><code>values=[
    [
      "229",
      25,
      "objective",
      [
        "49"
      ],
      "2019-07-24 08:59:39",
      "2019-07-24 08:59:39"
    ],
    [
      "229",
      26,
      "descriptive",
      [
        "Yes i have long term illness that limits my daily activities. Test..."
      ],
      "2019-07-24 08:59:39",
      "2019-07-24 08:59:39"
    ]
  ];
  var sql = 'INSERT INTO `answers` (`user_id`, `question_id`, `question_type`, `answer`, `created_at`, `updated_at`)  VALUES (?)';
  
  await connection.query(sql, values);
  </code></pre>