mysql2的用法

npm i mysql2

npm i kenx

const db = knex({
  client: 'mysql2',
  connection: {
    host: 'localhost',
    user: 'root',
    password: '111111',
    database: 'user'
  }
})

  let result = await db('userlist').where({ id: 4 }).update({ username: 'abbab' })
 let result = await db('userlist').insert({ username, password, gender, rule })
let result = await db('userlist').select().limit(2).offset(2).orderBy()
let result = await db('userlist').where({id:1}).del()

const mysql = require('mysql2')

const pool = mysql.createPool({host:'localhost', user: 'root', database: 'news'});

const promisePool = pool.promise();

promisePool.query(`INSERT INTO author (name, pass) VALUES (?,?)`,[username,password])

  // const data =await promisePool.query("SELECT * FROM `users` order by score limit 2 offset 1")
   //  const data = await promisePool.query(`select * from users where score>?`,[80])
    // const data = await promisePool.query(`INSERT INTO users (username, score, gender, class_id) VALUES (?,?,?,?)`,['ggg',11,1,1])
    // const data = await promisePool.query(`update users set username=? where id=?`,['qwer',11])
    // const data = await promisePool.query(`delete from users where username=?`,['ggg'])
   //  const data = await promisePool.query(`select * from movies where mid=?`,[1])
   //  const data1 = await promisePool.query(`select * from types where mid=1`) 

 const data = await promisePool.query(`select movies.filmId,movies.name,movies.actor,movies.director,movies.nation,movies.runtime,movies.category,movies.poster,movies.score,types.mName,movies.synopsis from movies inner join types on movies.mId=types.mId`)