express connect-mysql nuxt.js

express mysql

const express = require("express")
const app = express()

module.exports = {
  path: "/server",
  handler: app,
}

app.get("/category", (req, res) => {
  const mysql = require("mysql")
  const connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    database: "database-name",
    password: "type-your-password",
  })
  connection.connect()
  let sql = "select * from table-name"
  connection.query(sql, function (error, row, fields) {
    if (error) {
      console.log(error)
    }
    let dat = []
    for (let i = 0; i < row.length; i++) {
      dat.push({
        id: row[i].column-name,
        name: row[i].column-name,
      })
    }
    ret = JSON.stringify(dat)
    res.send(ret)
  })
  connection.end()
})