var express        =        require("express");
var bodyParser     =        require("body-parser");
var serv           =        express();
//Here we are configuring express to use body-parser as middle-ware.
serv.use(bodyParser.urlencoded({ extended: false }));
serv.use(bodyParser.json());
var mysql = require('mysql');
serv.listen(8080);
var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: ""
});

con.query('CREATE DATABASE IF NOT EXISTS bdd',function(err,rows,fields){
  if(err) throw err;
});
con.end();

var connection = mysql.createConnection({
  host:"localhost",
  user:"root",
  password:"",
  database:"bdd",
  multipleStatements:true
});
connection.connect();

connection.query('CREATE TABLE IF NOT EXISTS client(id INT UNSIGNED NOT NULL AUTO_INCREMENT, nom VARCHAR(50) NOT NULL, PRIMARY KEY (id))ENGINE=INNODB',function(err,rows,fields){
  if(err) throw err;
});

connection.query('INSERT INTO client(nom) VALUES("SOLAL")',function(err,rows,fields){
  if(err) throw err;
});

connection.query('SELECT * FROM client',function(err,rows,fields){
  if(err) throw err;
  console.log(rows);
});