# Is it possible to do MySQL INSERT INTO...SELECT Queries in Ignition? **URL:** \ **Category:** Ignition\ **Tags:** scripting\ **Created:** [February 19, 2025, 7:27pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-do-mysql-insert-into-select-queries-in-ignition/102586 "2025-02-19T19:27:32Z")\ **Posts on this page:** 1\ **Showing post:** 5
**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:** [February 19, 2025, 10:46pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-do-mysql-insert-into-select-queries-in-ignition/102586/5 "2025-02-19T22:46:04Z")
There's no way to run a single query that uses two JDBC connections. Sorry. If the receiving DB is a competent brand (supports SQL UNNEST()), you can move bulk data with arrays: > [@Taking a Dataset and Inserting it to a SQL temp table](https://forum.inductiveautomation.com/t/taking-a-dataset-and-inserting-it-to-a-sql-temp-table/83852/4): > > If you were using a competent database (the following is PostgreSQL), you can pass java arrays as arguments, and unnest() them in a FROM clause. For an example, I created a table in my psql forum playground called phrases, to be used in a join. When queried by itself, you get this dataset: "#NAMES" "prefix","suffix" "#TYPES" "str","I" "#ROWS","4" "Hello","1" "Good Bye","2" "Welcome to","3" "Whoa!","4" To go with that, in a custom property named lookups, I created the following unbound datase… --- _[View the full topic](https://forum.inductiveautomation.com/t/is-it-possible-to-do-mysql-insert-into-select-queries-in-ignition/102586)._