创建table
向表中写入数据
在项目中操作mysql数据库
const mysql = require('mysql')
const db = mysql.createPool({
host:'127.0.0.1',
user:'root',
password:'123456',
database:'new_db01'
})
const mysql = require('mysql')
const db = mysql.createPool({
host:'127.0.0.1',
user:'root',
password:'123456',
database:'new_db01'
})
db.query('select * from users',(err,results)=>{
if(err) return console.log('出错了!')
console.log(results)
})
查询数据
select语句,返回结果是数组
插入数据
insert into语句,返回结果是对象
占位符:?
const user = {username:'129377',password:'129377',staus:0}
const sqlStr = 'insert into users (username,password) values(?,?)'
db.query(sqlStr,[user.username,user.password,user.staus],(err,results)=>{
if(err) return console.log('插入出错了!')
//如果影响行数为1 则插入成功
if(results.affectedRows == 1){
console.log('插入成功')
}
})
插入数据的便捷方式
const user = {username:'1293773843',password:'1293773843',status:0}
const sqlStr = 'insert into users set ?'
db.query(sqlStr,user,(err,results)=>{
if(err) return console.log(err)
//如果影响行数为1 则插入成功
if(results.affectedRows == 1){
console.log('插入成功')
}
})
更新数据![](https://i-blog.csdnimg.cn/blog_migrate/06c07ba70943925cf59419230d92a652.png)
更新数据的便捷方式
const user = {id:6,username:'1293773843',password:'123456'}
const sqlStr = 'update users set ? where id=?'
db.query(sqlStr,[user,user.id],(err,results)=>{
if(err) return con