sql-for-node

Functions

| Function name | Function | |:-----|:----| | connection | Connect to database | | queryList | sql | | deleteInfo | sql | | addInfo | sql | | updateInfo | sql | | innerJoinInfo | sql | | leftJoinInfo | sql | | rightJoinInfo | sql | | mysql | third-party packages |

connection

  var sql = require('sql-for-node')

  sql.connection({
    host: 'localhost',
    user: 'root',
    password: '123456',
    port: '3306',
    database: 'XXX'
  })

queryList

await sql.queryList(tablename, accurate, fuzzy, order)

// tablename: string --tablename
// accurate: object --accurate query params ex:{id:123}
// fuzzy: object --fuzzy query params ex:{id:123}
// order: boolean --true: desc, false: asc

deleteInfo

await sql.deleteInfo(tablename, param)

// tablename: string --tablename
// param: object --delete query params ex:{id:123}

addInfo

await sql.addInfo(tablename, postData)

// tablename: string --tablename
// postData: object --postData ex:{name:"111",account:"223"}

updateInfo

await sql.updateInfo(tablename, param, putData)

// tablename: string --tablename
// param: object --update query params ex:{id:123}
// putData: object --putData ex:{name:"111",account:"223"}

innerJoinInfo

await sql.innerJoinInfo(tableName, tableName2, id)

// tablename: string --tablename
// tablename2: string --tablename2
// id: string --innerJoin query params ex:"id"

leftJoinInfo

await sql.leftJoinInfo(tableName, tableName2, id)

// tablename: string --tablename
// tablename2: string --tablename2
// id: string --leftJoinInfo query params ex:"id"

rightJoinInfo

await sql.rightJoinInfo(tableName, tableName2, id)

// tablename: string --tablename
// tablename2: string --tablename2
// id: string --rightJoinInfo query params ex:"id"