nodejs操作mysql遇到TypeError: val.slice is not a function

问题：

在使用nodejs向数据库增加数据库时，
遇到如下问题

G:\NODE.js\server_learn\node_mqtt\node_modules\sqlstring\lib\SqlString.js:202
    escapedVal += val.slice(chunkIndex, match.index) + CHARS_ESCAPE_MAP[match[0]];
                      ^

TypeError: val.slice is not a function
    at escapeString (G:\NODE.js\server_learn\node_mqtt\node_modules\sqlstring\lib\SqlString.js:202:23)
    at Object.escape (G:\NODE.js\server_learn\node_mqtt\node_modules\sqlstring\lib\SqlString.js:56:21)
    at Object.format (G:\NODE.js\server_learn\node_mqtt\node_modules\sqlstring\lib\SqlString.js:100:19)
    at Connection.format (G:\NODE.js\server_learn\node_mqtt\node_modules\mysql\lib\Connection.js:271:20)
    at Connection.query (G:\NODE.js\server_learn\node_mqtt\node_modules\mysql\lib\Connection.js:189:22)
    at add_data (G:\NODE.js\server_learn\node_mqtt\con_mysql.js:20:14)
    at MqttClient.<anonymous> (G:\NODE.js\server_learn\node_mqtt\index.js:34:5)
    at MqttClient.emit (events.js:375:28)
    at MqttClient._handlePublish (G:\NODE.js\server_learn\node_mqtt\node_modules\mqtt\lib\client.js:1277:12)
    at MqttClient._handlePacket (G:\NODE.js\server_learn\node_mqtt\node_modules\mqtt\lib\client.js:410:12)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! node_mqtt@1.0.0 start: `node index.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the node_mqtt@1.0.0 start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\16006\AppData\Roaming\npm-cache\_logs\2021-12-15T05_35_14_722Z-debug.log

解决办法

这表明你存入数据库的一个或多个值，有部分不是string类型
检查你传入数据库的参数，
用.toString()转变参数类型为string.
即可解决问题。