Node.js mysql - what is the difference between query and execute?

Question

MySQL

Hello. What is the difference between connection.query('SELECT...') and connection.execute('SELECT...') and also createConnection from createPool using mysql2/promise (ES7 Async Await)

Answer 1

What is the difference between connection.query and connection.execute

execute = prepare + query
When substituting variables into a query, query without prepare results in SQL injection.
RFTM https://github.com/sidorares/node-mysql2#using-pre...
One connection or many (to speed up parallel requests)
RTFM https://github.com/mysqljs/mysql#pooling-connections