var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "sistemas2018",
  database: "cursoReact"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  var sql = "INSERT INTO members (name, surname, email) VALUES ?";
  var values = [
    ['John', 'Hannah', 'hanna@gmail.com'],
    ['Peter','Pan', 'Lowstreet4@hotmail.com'],
    ['Amy', 'Apple', 'abcd@st652.net'],
    ['Hannah','Montana', 'Mountain21@haiku.io'],
    ['Michael', 'Mercado', 'oxxo@Valley345.sex'],
    ['Sandy', 'Ocean', 'cougar@blvd2'],
    ['Betty','La fea', 'asde@GreenGrass.com'],
    ['Richard', 'Sky st 331', 'abed@dsddas.com'],
    ['Susan', 'One way 98', 'abed@dsddas.com'],
    ['Vicky', 'Yellow', 'Garden@2222.com'],
    ['Ben', 'Park Lane', 'ascd@38.net'],
    ['William', 'Central', 'a@as.amd'],
    ['Chuck', 'Main', 'sas@road.net'],
    ['Viola', 'Marson', 'loco@Sideway.io']
  ];
  con.query(sql, [values], function (err, result) {
    if (err) throw err;
    console.log("Number of records inserted: " + result.affectedRows);
  });
});