បើសិនជាយើងចង់លុបតារាងទិន្នន័យណាមួយចេញពីមូលដ្ឋានទិន្នន័យ យើងចាំបាច់ត្រូវប្រើប្រាស់បញ្ជា «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