向數(shù)據(jù)庫(kù)添加數(shù)據(jù)
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) => {})
根據(jù)關(guān)鍵字查詢
var sql = "SELECT * FROM `AddOld` WHERE `title` LIKE ? ";
pool.query(sql, [obj.title], (err, result) => {})
根據(jù)關(guān)鍵字刪除
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模糊查詢時(shí)的問號(hào)(?)傳參
正常的sql的like操作:
select * from job_info where job_name like '%web%'
錯(cuò)誤的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 {}
})