NodeJs 不能同时执行多条Sql语句？

Winter2018-10-26

同时执行多条语句会报错：Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select found_rows() as total' at line 1

Winter2018/10/26 11:19:52

由于Node mysql做了安全的限制,想要执行多条sql语句，需要打开对应开关配置


var mysql = require('mysql');
var pool  = mysql.createPool({port:"..", host, "...", ... , multipleStatements: true});

在配置中添加multipleStatements: true

Newest Answer

HTML5 Drag & Drop 拖动时更改图标/光标

5 Answer

如何完全卸载 Node.js，然后从头重新安装 (Mac OS X)

NUXT引入tailwindcss报错Error: Expected an opening square bracket.

1 Answer