try catch vs if else

try {
    database.connect(() => console.log('Connected to MySQL!'));
} catch (e) {
    console.log(e);
}

const app = express();


// create a Table (works!)
app.get('/create', (req, res) => {
    let sql = 'CREATE TABLE node(id int AUTO_INCREMENT, title VARCHAR(255), body VARCHAR(255), PRIMARY KEY(id))';

    try {
        database.query(sql, result => {
            console.log(result);
            res.send("Successfully created table 'node'.");
        })
    } catch (e) {
        console.log(e);
    }
});


// insert records into 'node' table (works!)
app.get('/save', (req, res) => {
    let record = {title: 'MySQL With Node', body: 'Tutorial...blah blah...'};
    let sql = 'INSERT INTO node SET ?';

    try {
        database.query(sql, record, () => res.send('Record saved successfully!'));
    } catch (e) {
        console.log(e);
    }
});


// making multiple selections from the table (try catch does not work!)
app.get('/records', (req, res) => {
    let sql = 'SELECT * FROM node';

    database.query(sql, (err, records) => {
        if (err) { console.log(err); }
        else { console.log(records); }
    })

    // try {
    //     database.query(sql, records => console.log(records));
    // } catch (e) {
    //     console.log(e);
    // }
});


// making a single selection from the table  (try catch does not work!)
app.get('/record/:id', (req, res) => {
    let sql = `SELECT * FROM node WHERE id = ${req.params.id}`;

    database.query(sql, (err, record) => {
        if (err) { console.log(err); }
        else { console.log(record); }
    })

    // try {
    //     database.query(sql, record => console.log(record));
    // } catch (e) {
    //     console.log(e);
    // }
});


// updating a record  (try catch does not work!)
app.get('/update/:id', (req, res) => {
    let update = 'Cam show';

    let sql = `UPDATE node SET title = '${update}' WHERE id = ${req.params.id}`;

    database.query(sql, (err, result) => {
        if (err) { console.log(err); }
        else { console.log(result); }
    })

    // try {
    //     database.query(sql, record => console.log(record));
    // } catch (e) {
    //     console.log(e);
    // }
});


// deleting a record (works!)
app.get('/delete/:id', (req, res) => {

    let sql = `DELETE FROM node WHERE id = ${req.params.id}`;

    // database.query(sql, (err, result) => {
    //     if (err) { console.log(err); }
    //     else { console.log(result); }
    // })

    try {
        database.query(sql, result => {
            console.log(result);
            res.send('Record successfully deleted!');
        });
    } catch (e) {
        console.log(e);
    }
});

app.listen(port, () => console.log(`Server running on port ${port}`));