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

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 11, 2019, 5:45pm UTC](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826/2 "2019-01-11T17:45:15Z")

</div>

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.

---

_[View the full topic](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826)._