mysqls
mysqls copied to clipboard
It is written in JavaScript,crud for mysql.You can also use transactions very easily.
是否可以加入dateStrings:true配置
引入出错
import { execute,sql,transaction } from 'node-transform-mysql' sql undefined 怎么搞?
请问如何生成某个transaction对应的sql语句呢?
多表查询报错
sql.table({'node_table1': 'a', 'node_table2': 'b'}).where('id=1').select() 完全复制的示例,运行报错:(node:23224) UnhandledPromiseRejectionWarning: TypeError: opt.indexOf is not a function
sql.table('student').field(['id', 'name', {'user_name', 'userName'}]).select() 会有以下错误: sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use...
There is no api doc for count how many data i searched
let firstSql = sql.table('tb_parking_car').field(` isDel, action, id, carNumber, carOwer, carStatus, startTime, endTime, pastDueStatus, address, ps, phoneNum, link_parking_lot_number as parkingId `).order(conditionsOrder).select() let querySql = sql.table(firstSql) .field(` ss.isDel, ss.action, ss.id, ss.carNumber, ss.carOwer,...