常用SQL语句 node.js - express

向数据库添加数据

  var sql = "insert into AddOld(title,data) values(?,?)";
  pool.query(sql, [obj.title, obj.data], (err, result) => {}）

全部查询

 var sql = "SELECT title,data FROM AddOld";
 pool.query(sql, [obj.title, obj.data], (err, result) => {}）

根据关键字查询

 var sql = "SELECT * FROM `AddOld` WHERE `title` LIKE ? ";
  pool.query(sql, [obj.title], (err, result) => {}）

根据关键字删除

  var sql = "DELETE FROM `AddOld` WHERE `title` = ?";
  pool.query(sql, [obj.title], (err, result) => {}）

模糊查询
https://blog.csdn.net/weixin_39385430/article/details/103039764

NodeJS中Sql使用Like模糊查询时的问号(?)传参
正常的sql的like操作：
select * from job_info where job_name like '%web%'
错误的Node中的like写法：
var name = req.query.name;
let sql = "select * from job_info where job_name like '%?%'";
db.query(sql,name, (err, rows) => {
  if (err) {} else {}
  })
  
正确的写法
var name = "%" + req.query.name + "%";
let sql = "select * from job_info where job_name like ?";
db.query(sql,name, (err, rows) => {
  if (err) {} else {}
})