# Connection with MySQL

## What You'll Need <a href="#what-youll-need" id="what-youll-need"></a>

Backbench account - [Sign Up](https://bench.backbench.io/signup), the personal account will always remain free to use.

MySQL credentials - host, user and password.

## Prerequisites for the app <a href="#prerequisites-for-the-app" id="prerequisites-for-the-app"></a>

1. Basic knowledge of MySQL.
2. Knowledge of NodeJs.
3. MySQL credentials.

## Backend <a href="#backend" id="backend"></a>

1. Select +, in the upper right corner to create a Module. For example, say "package.json" and select CREATE or hit Enter.
2. Copy and paste the code module from below.

```javascript
{
    "dependencies": 
    {
        "mysql": "2.5.0"
    },
    "author": "Backbench”
}
```

A **package.json** file lists the packages that your project depends on. allows you to specify the versions of a package that your project can use using semantic versioning rules.

## Creating a database <a href="#creating-a-database" id="creating-a-database"></a>

* Now create another module to establish connection with MySQL.
* Select save.

```javascript
var mysql = require("mysql");
module.exports.endpoint = function(req, cb){
  var con = mysql.createConnection({
          host:"<host>",
          user: "<dbuser>",
          password: "<dbpassword>"
  });
   con.connect(function(err){
   console.log("Connected!");
   con.query("CREATE DATABASE backbench", function(err, result){
   console.log("Database created");
   cb(undefined, {msg:"Database created"})
        })
    })
    con.end();
}
```

Replace the name of your host , dbuser and password in the place of \<host>, \<dbuser> and \<dbpassword> respectively.

* Now go to endpoints in backbench console.
* Click on + button.&#x20;
* This will add an endpoint to the above module, let’s say “/sqldbcreate”.
* Go to the link

```javascript
https://<backbench username>-<name of your bench>.beta-bench.backbench.io/sqldbcreate.
```

You just created a database.

## Creating a table <a href="#creating-a-database" id="creating-a-database"></a>

* Now create another module to create a table in above  MySQL database.
* Select save.

```javascript
var mysql = require("mysql");

module.exports.endpoint = function(req, cb){
    var con = mysql.createConnection({
          host:"<host>",
          user: "<dbuser>",
          password: "<dbpassword>"
          database: "backbench"
    })

    con.connect(function(err){
        console.log("Connected");
        var sql = "CREATE TABLE employees (name VARCHAR(255), position VARCHAR(255))";
        con.query(sql, function(err, result){
            console.log("Table created");
            cb(undefined, {msg: "table created"})
        })
    })

    con.end();
}
```

Replace the name of your host , dbuser and password in the place of \<host>, \<dbuser> and \<dbpassword> respectively.

* Now go to endpoints in backbench console.
* Click on + button.&#x20;
* This will add an endpoint to the above module, let’s say “/sqltablecreate”.
* Go to the link

```javascript
https://<backbench username>-<name of your bench>.beta-bench.backbench.io/sqltablecreate.
```

You just created a table.

## Inserting data in a table <a href="#creating-a-database" id="creating-a-database"></a>

* Now create another module to insert data into a table in above  MySQL database.
* Select save.

```javascript
module.exports.endpoint = function(req, cb){
    var con = mysql.createConnection({
        host:"<host>",
        user: "<dbuser>",
        password: "<dbpassword>"
        database: "backbench"

    })

    con.connect(function(err){
        console.log("Connected");
        var sql = "INSERT INTO employees (name, position) VALUES ?";
        var values = [
            ["Hi" , "Welcome"],
            ["Good" , "Day"],
            ["Now" , "It's raining"],
        ];
        con.query(sql, [values], function(err, result){
            console.log("Values Inserted");
            cb(undefined, {msg: "values inserted"})
        })
    })

    con.end();
}
```

Replace the name of your host , dbuser and password in the place of \<host>, \<dbuser> and \<dbpassword> respectively.

Now go to endpoints in backbench console.

* Click on + button.&#x20;
* This will add an endpoint to the above module, let’s say “/sqlinsertdata”.
* Go to the link

```javascript
https://<backbench username>-<name of your bench>.beta-bench.backbench.io/sqlinsertdata.
```

You just inserted values into a table.

## Updating data in a table <a href="#creating-a-database" id="creating-a-database"></a>

* Now create another module to update data into a table in above  MySQL database.
* Select save.

```javascript
var mysql = require("mysql");

module.exports.endpoint = function(req, cb){
    var con = mysql.createConnection({
          host:"<host>",
          user: "<dbuser>",
          password: "<dbpassword>"
          database: "backbench"


    })

    con.connect(function(err){
        con.query("UPDATE employees SET position = 'Hi' WHERE name = 'Welcome to backbench'", function(err, result, fields){
            console.log(result);
            cb({msg: "Updated"})
        })
    })
}
```

Replace the name of your host , dbuser and password in the place of \<host>, \<dbuser> and \<dbpassword> respectively.

* Now go to endpoints in backbench console.
* Click on + button.&#x20;
* This will add an endpoint to the above module, let’s say “/sqlupdatedata”.
* Go to the link

```javascript
https://<backbench username>-<name of your bench>.beta-bench.backbench.io/sqlupdatedata.
```

You just updated values into a table.

## Deleting data in a table <a href="#creating-a-database" id="creating-a-database"></a>

* Now create another module to delete data into a table in above  MySQL database.
* Select save.

```javascript
var mysql = require("mysql");

module.exports.endpoint = function(req, cb){
    var con = mysql.createConnection({
          host:"<host>",
          user: "<dbuser>",
          password: "<dbpassword>"
          database: "backbench"


    })

    con.connect(function(err){
        con.query("DELETE FROM employees where position='Hi'", function(err, result){
            console.log(result);
            cb(undefined, {msg: "Deleted"})
        })
    })
}
```

Replace the name of your host , dbuser and password in the place of \<host>, \<dbuser> and \<dbpassword> respectively.

* Now go to endpoints in backbench console.
* Click on + button.&#x20;
* This will add an endpoint to the above module, let’s say “/sqldeletedata”.
* Go to the link

```javascript
https://<backbench username>-<name of your bench>.beta-bench.backbench.io/sqldeletedata.
```

You just deleted values into a table.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://backbench.gitbook.io/backbench-docs/3rd-party-integrations/connection-with-mysql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.