Jmeter异常Update Statement:You have an error in your SQL syntax; check the manual that corresponds to

一、异常如下:

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 * from alei' at line 2

二、解决方案如下:

Jmeter异常Update Statement:You have an error in your SQL syntax; check the manual that corresponds to

2.1 注意带有select查询的操作要在Database URL添加如下内容:

&allowMultiQueries=true

Jmeter异常Update Statement:You have an error in your SQL syntax; check the manual that corresponds to

2.2 请求成功

Jmeter异常Update Statement:You have an error in your SQL syntax; check the manual that corresponds to

 

@希望能帮到大家!