sp-mysql
super-project moudle for mysql operate.
Usage
Init
Config More: https://github.com/mysqljs/mysql#connection-options
const config = host: '127.0.0.1' port: '3306' user: 'xxxx' password: 'xxxx' database: 'db_name' const mysql = config
Query
let sql = 'SELECT 1 + 1 AS Test'let result = await mysql // result 查询结果并保护下面数据// { affectedRows, insertId } = result
Debug
Use debug for log.
设置环境变量
set DEBUG=* # 全部信息 set DEBUG=MySQL* # MySQL相关信息,包括(info\log\errro) set DEBUG=MySQL:info # info信息 set DEBUG=MySQL:log # log信息,执行sql set DEBUG=MySQL:error # error错误信息
Test Connection
mysql // console => MySQL:info DB ['db_name'] connected √// => MySQL:info DB ['db_name'] connect failed X