# Named Query - MySQL SET Variable Not Working

**URL:** <https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895>\
**Category:** Ignition\
**Created:** [January 15, 2019, 7:45pm UTC](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895 "2019-01-15T19:45:38Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![mcgheeiv](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\
**Post date:** [January 17, 2019, 10:39am UTC](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895/5 "2019-01-17T10:39:42Z")

</div>

> [@Using a MySQL variable in a data query throwing me an error](http://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826/4):
>
> If you add allowMultiQueries = true to the Extra Configuration Properties in the advanced database connection properties, you should be able to use MySQL variables in the query. The query, however, can only return one dataset. [https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html](https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html)

---

_[View the full topic](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895)._