CRUD-запросы

const mysql = require('mysql');
const express = require('express');
var app = express();
const bodyparser = require('body-parser');
 
app.use(bodyparser.json());
 
var mysqlConnection = mysql.createConnection({
    host:'localhost',
    user:'root',
    password:'123456',
    database:'names',
    multipleStatements: true
});
 
mysqlConnection.connect((err)=>{
    if(!err)
        console.log('DB connection succeded');
    else
        console.log('DB connection failed \n Error: ' + JSON.stringify(err, undefined, 2));
});
 
 
app.listen(3000, ()=>console.log('Server is running at port 3000'));
 
// Получение всего списка
app.get('/index.html', (req, res)=>{
    mysqlConnection.query('SELECT * FROM names', (err, rows, fields)=>{
        if (!err) console.log(rows);
        else console.log(err);
    });
});
 
// Получение элемента
app.get('/index.html/:id', (req, res)=>{
    mysqlConnection.query('SELECT * FROM names WHERE Name = ?', [req.params.id], (err, rows, fields)=>{
        if (!err) console.log(rows);
        else console.log(err);
    });
});
 
// Удаление элемента
app.delete('/index.html/:id', (req, res)=>{
    mysqlConnection.query('DELETE FROM names WHERE Name = ?', [req.params.id], (err, rows, fields)=>{
        if (!err) res.send('Contact deleted');
        else console.log(err);
    });
});
 
// Создание элемента
app.post('/index.html', (req, res)=>{
    let con = req.body;
    var sql = "SET @Name = ?; SET @Number = ?; CALL New(@Name, @Number);";
    mysqlConnection.query(sql,[con.Name, con.Number], (err, rows, fields)=>{
        if (!err) res.send(rows);
        else console.log(err);
    });
});