បើសិនជា​យើងចង់លុប​តារាង​ទិន្នន័យ​ណា​មួយ​ចេញពី​មូលដ្ឋាន​ទិន្នន័យ​ យើងចាំបាច់​ត្រូវ​ប្រើប្រាស់​បញ្ជា «DROP TABLE» នៃ​ភាសា SQL ដោយ​ធ្វើដូចខាងក្រោម​នេះ៖

 

import express from 'express'
import path from 'path'
const app = express()
const port = process.env.PORT || 3000
const __dirname = path.resolve()
import index from './routes/index.js'
import backend from './routes/backend.js'
import con from './models/connectMySQL.js'
app.use('/',function(req,res,next){
req.con = con
req.__dirname = __dirname
next()
})
app.set('views', path.join(__dirname, 'views'))
app.set('view engine', 'ejs')
app.use(express.static(path.join(__dirname, 'public')))
app.use(express.urlencoded({extended:false}))
app.use(express.json())
app.use('/',index)
app.use('/backend',backend)
app.listen(port,function(){
console.log(`This application is listening to the port: ${port}`)
})

 

/* ./routes/index.js */
import express from 'express'
import func from '../models/mysql.js'
const index = express.Router()
index.use(func)
index.get('/',(req,res)=>{
res.render('base',req.data)
})
export default index

 

//models/mysql.js
function deleteTable(req,res,next){
let sql = `DROP TABLE users`
req.con.query(sql,function(err,result){
if(err) throw err
req.data = {}
req.data.message = `Table was dropped`
next()
})
}
export default deleteTable