express:TypeError: Cannot read property 'query' of undefined

Question

// 建立连接 增加一个用户信息 
connection.query(Sql.insert, [param.name,param.password,email,sex], function(err, result) {
        if(result) {      
             result = {   
                      code: 200,   
                     msg:'增加成功'
             };  
        }  

***TypeError: Cannot read property 'query' of undefined***
    at /usr/myapp2/routes/index.js:20:11
    at Handshake.onConnect (/usr/myapp2/node_modules/mysql/lib/Pool.js:58:9)
    at Handshake.Sequence.end (/usr/myapp2/node_modules/mysql/lib/protocol/sequences/Sequence.js:86:24)
    at Protocol.handleNetworkError (/usr/myapp2/node_modules/mysql/lib/protocol/Protocol.js:364:14)
    at PoolConnection.Connection._handleNetworkError (/usr/myapp2/node_modules/mysql/lib/Connection.js:428:18)
    at emitOne (events.js:96:13)
    at Socket.emit (events.js:188:7)
    at emitErrorNT (net.js:1278:8)
    at _combinedTickCallback (internal/process/next_tick.js:74:11)
    at process._tickCallback (internal/process/next_tick.js:98:9)

有个错误 ，读不到query。

Answer 1

问题找到了，是因为我没有加载mysql依赖

Answer 2

您好，我也遇到这个问题了，请问您是怎么解决的呢？ 我在本地是没有问题的，上传到服务器上之后就报这个错误。