# 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:** 3

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [January 15, 2019, 8:23pm UTC](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895/3 "2019-01-15T20:23:30Z")

</div>

> [@Using a MySQL variable in a data query throwing me an error](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826/2):
>
> Ignition (and JDBC) doesn’t like _ **any** _ database’s variables. Because they are all vendor specific scripts, not standard SQL. JDBC expects you to execute one and only one statement per call.

A similar issue was posted not too long ago with the following better explanation.

---

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