查询队列指的是什么
在官方文档的Introduction部分其实就讲到了,文档传送门:Every method you invoke on a connection is queued and executed in sequence.Closing the connection is done using end() which makes sure all remaining queries are executed before sending a quit packet to the mysql server.
举例,下面的两个调用,在内部是排队执行的。connection.query('SELECT * FROM hello');
connection.query('SELECT * FROM world');
end、destroy的区别
两者的区别很明显,还是以前面的代码为例子。
1、connection.end():把查询1、查询2顺利执行完,得到查询结果后,断开mysql服务器的连接。
2、connection.destryo():直接断开连接,不管还有多少查询没执行完。
connection.query('SELECT * FROM hello'); // 查询1
connection.query('SELECT * FROM world'); // 查询2