# Using a MySQL variable in a data query throwing me an error

**URL:** <https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826>\
**Category:** Ignition\
**Tags:** database\
**Created:** [January 11, 2019, 4:39pm UTC](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826 "2019-01-11T16:39:22Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:37am UTC](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826/4 "2019-01-17T10:37:41Z")

</div>

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/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826)._