Node mysql table create and insert example

Node-mysql

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'mysql'
});

connection.connect();

connection.query('CREATE TABLE test.table1(Col1 VARCHAR(10), Col2 VARCHAR(50))', function(err, rows, fields) {
// connection.query('INSERT INTO test.table1 VALUES("blahblah", "blahblah2")', function(err, rows, fields) {

  if (err) throw err;

  // console.log('The solution is: ', rows[0].solution);
});

connection.end();