# MySQL Statement is not working

**URL:** <https://forum.inductiveautomation.com/t/mysql-statement-is-not-working/72252>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [April 10, 2023, 10:50am UTC](https://forum.inductiveautomation.com/t/mysql-statement-is-not-working/72252 "2023-04-10T10:50:18Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [April 10, 2023, 11:56am UTC](https://forum.inductiveautomation.com/t/mysql-statement-is-not-working/72252/5 "2023-04-10T11:56:19Z")

</div>

In general, JDBC doesn't support SQL _scripts_, just **single** SQL _statements_. If you want SQL that is widely compatible, don't use DECLARE, or BEGIN/END blocks, et cetera.

Some JDBC drivers support scripts, and others do not. Don't use them, and don't assume something that works in a workbench will work in Ignition.

---

_[View the full topic](https://forum.inductiveautomation.com/t/mysql-statement-is-not-working/72252)._